UserID
ProductCompanyID
ProductID
FundCompanyID
FundID
There are requirements however to ensure that a user can only run Reports for Product Companies to which they are assigned. This can be done as follows:
- Right click outside of the Report in the layout tab to open the Report parameters box
- Create a Parameter with the name UserID in the Report and return a list of active users in the Database to populate it in the available values
- Make this parameter 'Hidden'
- Make your Product Company parameter dependent on the UserID
The Report User Parameter then 'matches' to the application UserID and defaults to the logged in value, ensuring the Product Company dropdown is filtered correctly. It is hidden so the user cannot change it, thus disabling it.
Only the text and case of the Parameter names in the RDL is important. It doesn't matter what the Label is, or the name of the parameters in the Datasets.
No comments:
Post a Comment