Question
how to restrict some users to access data from report definitin?
Hi,
I have a report definition which return 50 records. For a manager user it should display all the 50 rows and for other user role only 30 records should be display and other 20 records should be masked with 'x'. How can we achieve this scenario. TIA
Even though we circumstance RD the report need to fetch from same table. In this case circumstance might not be useful.
Use column format in Report Definition and show value of columns conditionally (either value or "X" with Access Group condition)
I don't see any option in RD column configuration to show values of columns conditionally. Can you bit elaborate this. TIA
Accepted Solution
Create a custom control to show values of columns conditionally with Access group and use this control in RD as column format(Please click on gear icon for each column )
Hi ,
Try to circumstance the rule e.g. based on when condition and then you can mention the maximum number of records to be retieved in the Report Defination. I am not sure for, how you can get the ** for last 20 record.