asked on

SSRS 2008: Can 'Display can be toggled by this report item' be optional?

Hi guys

I have an SSRS 2008 report using a single data set as a source. No problems.

I'd like to add a ... Can 'Display can be toggled by this report item' ... to the first column, but ONLY for the Total Deliveries and Total Receipts lines. SO the +/- button would show for these two, and expand and collapse normally (I'll throw in a subreport here, no problem) and NOT show for the others.

Is this possible?

Thanks in advance.
Jim

ASKER CERTIFIED SOLUTION

Mike Eghtebas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Horn

ASKER

Thanks.

I have the rows showing / hiding. Added a row inside the group below the detail, merged all cells, added a subreport to the cell, set parameters, and then changed the row visibility to..

=IIF(Fields!row_label.Value="Total Deliveries", False, True)

Open in new window

Working on the toggle now.

SOLUTION

Mike Eghtebas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Eghtebas

I think you would like this solution.

Please see the image:
HideCertainCategories.png

Jim Horn

ASKER

At the moment the above image appears to be the only viable solution, to force the first subform (front brakes, rear brakes, ...) to always be open, as SSRS doens't have any functionality to conditionally toggle, and doesn't have a command button where you can write code on a click event.

Continuing...

Mike Eghtebas

re:>... first subform ...
There is no subform in this image.

The attached image gives you +/- option if it is desirable to have.

Mike
ShowExpandedWithPlusMinus.png

Mike Eghtebas

=iif((Fields!Category.Value="Brakes" OR Fields!Category.Value="Cranksets"),False, True)

for expression, to have more than one item displayed.
ShowExpandedWithPlusMinus.png

Jim Horn

ASKER

I was able to convince the client that conditional toggles was not possible, and they are going to decide if the breakdown will (a) always be visible for 'Total Deliveries', or (b) I'll create a separate report / drillthrough via the click event on 'Total Deliveries'.

Thanks for you help.
Jim