I tried it on a report I did last week with two levels of grouping and a
detail line. By default the report shows only the top level grouping.
However, with the solution suggested below I was able to get the second level
grouping and the detail to be visible (or not visible).
Are you changing the Visibility/Hidden attribute for two different rows, or
is one a row and another a textbox or a sub-report?
~ Magendo_man
[quoted text, click to view] "Chris Pratt" wrote:
> I can get this working for one level of grouping, but for two it does not
> seem to. I can get level one expanded, but then level two refuses to show
> any of its rows.
>
> Is it possible to elaborate on this solution?
>
> Many thanks for your help.
>
> "magendo_man" <magendoman@discussions.microsoft.com> wrote in message
> news:4A2D232D-C462-4576-B59A-4DA8A179D6E8@microsoft.com...
> > You could have a boolean report parameter called "Expand All". Then on
> > your
> > report rows' Visibility/Hidden attribute use the expression:
> >
> > =Not(Parameters!ExpandAll.Value)
> >
> > HTH,
> > Magendo_man
> >
> > "Bob Myles" wrote:
> >
> >> Is it possible to "Expand ALL" levels of a summarized report? I have a
> >> report that has 3 levels of detail, with about 10 main items, a couple
> >> items
> >> under that and 4 or so items each under there, it gets tiresome real
> >> quick
> >> to click all the little pluses...
> >>
> >> When I export it to Excel 2000 there are three little boxes at the top of
> >> the expand columns (1,2,3) and I can click the level of detail I want to
> >> show
> >> by using these buttons... Really cool.
> >>
> >> Can that work in Report Services directly?
> >>
> >> --
> >> Thanks,
> >> Bob Myles
>
>
I can get this working for one level of grouping, but for two it does not
seem to. I can get level one expanded, but then level two refuses to show
any of its rows.
Is it possible to elaborate on this solution?
Many thanks for your help.
[quoted text, click to view] "magendo_man" <magendoman@discussions.microsoft.com> wrote in message
news:4A2D232D-C462-4576-B59A-4DA8A179D6E8@microsoft.com...
> You could have a boolean report parameter called "Expand All". Then on
> your
> report rows' Visibility/Hidden attribute use the expression:
>
> =Not(Parameters!ExpandAll.Value)
>
> HTH,
> Magendo_man
>
> "Bob Myles" wrote:
>
>> Is it possible to "Expand ALL" levels of a summarized report? I have a
>> report that has 3 levels of detail, with about 10 main items, a couple
>> items
>> under that and 4 or so items each under there, it gets tiresome real
>> quick
>> to click all the little pluses...
>>
>> When I export it to Excel 2000 there are three little boxes at the top of
>> the expand columns (1,2,3) and I can click the level of detail I want to
>> show
>> by using these buttons... Really cool.
>>
>> Can that work in Report Services directly?
>>
>> --
>> Thanks,
>> Bob Myles
