asked
Dynamic SSRS Report based on Query
Is it possible to dynamically choose a report based on a dynamic value? For example. I have 2 types of users. Standard, and Intermediate. I want to embed a report into a sharepoint page which, dependant on the USERID of the person running the report it would present the relevant report. Initially I thought a landing report which basically chose a subreport based on an initial query to identify which report should display, but it seems you cannot choose the subreport with an expression ie IF USERID.Group = standard then open x else open y. Please help?
Could you not handle this with groups? Assign the users to different groups depending on standard or intermediate and only display the appropriate report to each group? I work with SSRS a little bit but don't work with SharePoint so I am not sure of the bells and whistles with it. With SSRS I can limit who sees what based on roles and memberships.
Hi , You could have 2 sub reports in a single report and toggle the visibility between the reports based on the user who is running the report. Toggling the visibility can be achieved using expressions in the visibility property of the data region. Cheers, Nk
Trade ... its not about permissions of data its about displaying 2 completely different reports. I think kannan is onto something though I will try that tomirriw thanks. Excuse typos this new xoom is taking some getting used to,
