I build a report use dataset . FROM Application.Project INNER JOIN Application.Project/Application.SalesMan/Application.Account GROUP BY Application.Account/Name SELECT Application.Account/FullName as Name, COUNT(Application.Account/FullName) as Amount, SUM(Application.Project/Price) as Price, SUM(case when Application.Project/"Quarter" = 1 then Application.Project/Price else 0 end ) as Q1, SUM(case when Application.Project/"Quarter" = 2 then Application.Project/Price else 0 end ) as Q2, SUM(case when Application.Project/"Quarter" = 3 then Application.Project/Price else 0 end ) as Q3, SUM(case when Application.Project/"Quarter" = 4 then Application.Project/Price else 0 end ) as Q4 OQL have not err. I add a param named year, but I never use it in this OQL. when I run the server, this report will send this error : The report cannot be opened because the user does not have sufficient rights to access parameter Year I find param Year only be a Object, otherwise be take this error. (i use type int and datatime throw error both)
asked
money dragon
1 answers
2
Check your security. If you do not use the year parameter does it matter to give the user access rights to that attribute? Or remove the parameter if you do not use it anyway.