September 13, 2015 at 3:04 pm
I am currently working on an SSRS Bulk generation solution for creating multiple reports for various consumers within my organisation. I have taken the basis for this solution from and article by Siddharth Mehta on technet :https://technet.microsoft.com/en-us/library/ff793463(v=sql.105).aspx.
This solution works well for simple reports with relatively straight forwards parameters. However for some of our reports where the relationships between parameters vary this solution needs to be amended.
Some of our reports are defined by 3 parameters that are hierarchical. Branch, entity and department. If a user has rights at the branch level then they can see all data for the entities and departments that are associated with the branch. A user can also have access at the entity level and may therefore see all the departments associated with that entity and nothing else.
For example consider the following scenario. A user has access to Branch UTR. Branch UTR is linked to Entities 1001 and 1002. 1002 is linked to department A and B. 1002 is linked to department C and D. This user should be able to see all data from Branch UTR, Entities 1001, 1002 and departments A B C AND D.
Consider another Branch CAN. It is associated with entity 1003 which in turn is associated with department A and B. The same user is given access to entity 1003 and department B. Therefore the if a report for this user is run they should data for the following combinations of parameter values:
Branch: UTR, Entity: 1001 1002, Department: A,B,C,D
Entity: 1003, Department B
The problem I have is how to pass these different combinations of parameters to parameters for the report and render the corresponding data for them in one report. Based on the script task from the article above I can only send one combination of parameter values to the report to be rendered. Does anybody have any ideas how i could do this?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply