I have a drilldown report where with 2 levels . It's expand/collapse fine
when you view the report, but when you export
the report to Excel, it no longer has the collapsable operation in the Excel.
What i need to do to able to expand/collapse report in the Excel?
Thanks.Unfortunately,
It's not possible to get expand/collapse with exporting RS report to Excel
(exporting functionality is insufficient).
All rows are static.
Regards,
Radoslaw Lebkowski
U¿ytkownik "JT" <JT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:E6E32FB3-D62C-40FC-98D4-48162E210AE6@.microsoft.com...
>I have a drilldown report where with 2 levels . It's expand/collapse fine
> when you view the report, but when you export
> the report to Excel, it no longer has the collapsable operation in the
> Excel.
> What i need to do to able to expand/collapse report in the Excel?
> Thanks.|||That's not true all other reports works fine. I able to expand/collapse in
the excel. it's just one report is not working.
"Radoslaw Lebkowski" wrote:
> Unfortunately,
> It's not possible to get expand/collapse with exporting RS report to Excel
> (exporting functionality is insufficient).
> All rows are static.
> Regards,
> Radoslaw Lebkowski
>
> U¿ytkownik "JT" <JT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
> news:E6E32FB3-D62C-40FC-98D4-48162E210AE6@.microsoft.com...
> >I have a drilldown report where with 2 levels . It's expand/collapse fine
> > when you view the report, but when you export
> > the report to Excel, it no longer has the collapsable operation in the
> > Excel.
> > What i need to do to able to expand/collapse report in the Excel?
> >
> > Thanks.
>
>
Showing posts with label levels. Show all posts
Showing posts with label levels. 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)