topic Drop down for the subreport in Report Server

Drop down for the subreport

Aartibhilare — Fri, 31 Jan 2025 02:17:28 GMT

Hi team,

I need to include 10 subreports within a single report. Is there a way to implement a dropdown to select between them?

If so, how can we achieve this?

From what I know, we can embed all the reports and set visibility conditions. However, these reports need to work with the access restrictions defined in our SQL database and queries. What would be the most straightforward approach to manage this?

Re: Drop down for the subreport

rohit1991 — Tue, 08 Jul 2025 12:08:30 GMT

Hi Aartibhilare ,
Dropdown for Subreports in Power BI Report Server

Solution: Use a Parameter to Control Visibility

Create a Parameter (ReportSelector) → List subreport names.
Insert 10 Subreports → Place all in the main report.
Set Visibility for Each Subreport
- Use: =IIF(Parameters!ReportSelector.Value = "Report1", False, True)
- Repeat for each subreport.
Access Control:
- Filter available reports based on user roles in SQL.

Re: Drop down for the subreport

Aartibhilare — Sun, 02 Feb 2025 21:44:01 GMT

rohit1991

Thanks Rohit

topic Drop down for the subreport in Report Server

Drop down for the subreport

Re: Drop down for the subreport

Hi Aartibhilare ,Dropdown for Subreports in Power BI Report Server

Re: Drop down for the subreport

Hi Aartibhilare ,
Dropdown for Subreports in Power BI Report Server