0

I am using OQL to generate a report using parameters. The 3 parameters are some entities having a 1-N relation, like: User <- A <- B <- C I would like to limit the drop down list of parameter A to the only those records where the user has access to I would like to limit the drop down list of parameter B to only those records which are linked to what is selected under A I would like to limit the drop down list of parameter C to only those records which are linked to what is selected under B Within the data set it is possible to set Constraints on the parameters, but I cannot succeed in achieving the above. Eg: the constraint on the first parameter [Module.A_Account = '[%CurrentUser%]'] does not work Eg: for the second and third parameters I cannot get a correct syntax Any ideas on how I can achieve this?

asked 2016-07-07

0 answers