We are implementing toggle items (twistie: +) for some rows in our
reports. We would like to know if there is an expand/collapse all
functionality that we can use, to basically expand or collapse all
twisties on click?
Please advice. Thanks in advance.SQL Server 2000 Reporting Services RTM / SP1 does not support
expand/collapse all
It is on the feature wish list.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"bench" <bench_five@.yahoo.com> wrote in message
news:549f50b4.0408260315.599ee265@.posting.google.com...
> We are implementing toggle items (twistie: +) for some rows in our
> reports. We would like to know if there is an expand/collapse all
> functionality that we can use, to basically expand or collapse all
> twisties on click?
> Please advice. Thanks in advance.
Showing posts with label items. Show all posts
Showing posts with label items. Show all posts
Wednesday, March 7, 2012
Sunday, February 26, 2012
Expand ALL
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 MylesYou 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.
"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 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
"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
>
>
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 MylesYou 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.
"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 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
"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
>
>
Subscribe to:
Posts (Atom)