Grouping

Is there a way to fully expand (or vice versa) a report with groupings and
hidden levels? (Something like the Excelâ's subtotal groupings functionalities
would be ideal). The picture below displays exactly the two controllers we
requireâ?¦ (normal and level expand)You could do this by having a boolean report parameter called something like
HideDetail. Then in the detail row's hidden property use the expression
=Parameters!HideDetail
You could use similar parameters for a multi-level grouped report.
HTH,
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Kostas Bourikas" wrote:
> Is there a way to fully expand (or vice versa) a report with groupings and
> hidden levels? (Something like the Excelâ's subtotal groupings functionalities
> would be ideal). The picture below displays exactly the two controllers we
> requireâ?¦ (normal and level expand)sql

group properties

Hello,
I added a group to my report but I could not get a plus sign on it so that I
can click to expand and collapse, how can I put + there?
Thank,
Jim.Are you using a tabular report? If so highlight the entire detail row below
the group level. (Click on the row selector with three dashes icon on the
left of the table to do this). Go to the properties sheet, keeping the row
selected. Expand the Visibility property in the Properties sheet. Set the
Hidden property to True, and for the ToggleItem, specify a field which is in
the Group section.
HTH
Charles Kangai, MCT, MCDBA
"JIM.H." wrote:
> Hello,
> I added a group to my report but I could not get a plus sign on it so that I
> can click to expand and collapse, how can I put + there?
> Thank,
> Jim.
>