Share via

I need help getting my drill downs to work right in a SSRS report

Anonymous
2022-09-06T22:50:38.127+00:00

I am fairly new to SSRS so any help would be appreciated. I have a SSRS report that everything works as expected except the drill downs for the report do not work right.
When i click on the first drill down it suppose to only show me the bottom portion of the table.
238280-drill-down-1.png
and when I click on the third plus sign it suppose to show me the two bottom tables.

238349-drilldown-2.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,067 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-07T07:01:15.89+00:00

    Hi @Jannette Jones
    It seems that a table can only be controlled by one ToggleItem. If you want to control a table via 2 ToggleItems, then duplicating the table and controlling it by another ToggleItem might be a workaround.
    For details about drilldown action, you can refer to this link: add-an-expand-or-collapse-action-to-an-item-report-builder-and-ssrs.
    Best regards,
    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.