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 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?

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.

     

2 Replies

  • 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.