CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2016
bmsqldev
bmsqldev

Reputation: 2735

Display Different report based on a parameter value in SSRS

We have an SSRS Report which uses user authentication. I have requirement as below

If an unauthorized user login to see SSRS Report, He/She should only see the "You are not authorized error" message. He/She should not have any visibility to report parameters or any other report elements.

Below is what I have done.

I Created a new parameter in the report to store the user-access value. If the value is 'Y' report will be shown. Else hide the report and show only the tablix with the error message. However, parameter panel is visible in both cases. I need the parameter panel to be hidden in the Report when the error message displays.

Is it possible to call a sub-report and show it with hidden parameters if the user-access parameter value set as "N" instead of actual report?

Thanks baiju

Upvotes: 0

Views: 1278

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

Is it possible to call a sub-report and show it with hidden parameters if the user-access parameter value set as "N" instead of actual report?

Yes, sort of. What you would actually do is have both reports be sub-reports. Your main report would just be a wrapper for the sub-reports, and the parameter would determine which sub-report you show.

Upvotes: 1

Related Questions