Forum Discussion

Aartibhilare's avatar
Aartibhilare
Helper III
1 year ago
Solved

Drop down for the subreport

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 t...
Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi Aartibhilare ,
    Dropdown for Subreports in Power BI Report Server

    Solution: Use a Parameter to Control Visibility

    1. Create a Parameter (ReportSelector) → List subreport names.
    2. Insert 10 Subreports → Place all in the main report.
    3. Set Visibility for Each Subreport
      • Use: =IIF(Parameters!ReportSelector.Value = "Report1", False, True)
      • Repeat for each subreport.

    4. Access Control:

      • Filter available reports based on user roles in SQL.

     

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi Aartibhilare ,
Dropdown for Subreports in Power BI Report Server

Solution: Use a Parameter to Control Visibility

  1. Create a Parameter (ReportSelector) → List subreport names.
  2. Insert 10 Subreports → Place all in the main report.
  3. Set Visibility for Each Subreport
    • Use: =IIF(Parameters!ReportSelector.Value = "Report1", False, True)
    • Repeat for each subreport.

  4. Access Control:

    • Filter available reports based on user roles in SQL.