Expand All/Collapse All feature

1. Is there a way to Expand All nodes or Collapse All Nodes in a drill-down
report designed with RS ? I find it annoying to click every + sign to open
all nodes. Maybe, there is an easier way that I do not know.
2. When the same drill-down report is partially expanded and I export the
report as-it-is to Excel, the exported file has only the partial
data.....only the data that was expanded. The other data is never exported.
What can I do to resolve this ?
Please respond.You can add logic to the Visibility property of each collapable item on the
report and link it to a report parameter. This solution would require a
round trip to the server each time. Others might have additional
suggestions...
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"DC" <dc@.discussions.microsoft.com> wrote in message
news:eAo4xY91EHA.1192@.tk2msftngp13.phx.gbl...
> 1. Is there a way to Expand All nodes or Collapse All Nodes in a
> drill-down
> report designed with RS ? I find it annoying to click every + sign to open
> all nodes. Maybe, there is an easier way that I do not know.
> 2. When the same drill-down report is partially expanded and I export the
> report as-it-is to Excel, the exported file has only the partial
> data.....only the data that was expanded. The other data is never
> exported.
> What can I do to resolve this ?
> Please respond.
>|||I have not received any response on this yet. Can somebody help ?
"DC" <dc@.discussions.microsoft.com> wrote in message
news:eAo4xY91EHA.1192@.tk2msftngp13.phx.gbl...
> 1. Is there a way to Expand All nodes or Collapse All Nodes in a
drill-down
> report designed with RS ? I find it annoying to click every + sign to open
> all nodes. Maybe, there is an easier way that I do not know.
> 2. When the same drill-down report is partially expanded and I export the
> report as-it-is to Excel, the exported file has only the partial
> data.....only the data that was expanded. The other data is never
exported.
> What can I do to resolve this ?
> Please respond.
>|||Hmmmm... did you miss my post? There is also an answer to your repost.
Here was my suggestion:
You can add logic to the Visibility property of each collapable item on the
report and link it to a report parameter. This solution would require a
round trip to the server each time. Others might have additional
suggestions...
Cheers,
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"DC" <dc@.discussions.microsoft.com> wrote in message
news:O6td5kI2EHA.2112@.TK2MSFTNGP15.phx.gbl...
>I have not received any response on this yet. Can somebody help ?
> "DC" <dc@.discussions.microsoft.com> wrote in message
> news:eAo4xY91EHA.1192@.tk2msftngp13.phx.gbl...
>> 1. Is there a way to Expand All nodes or Collapse All Nodes in a
> drill-down
>> report designed with RS ? I find it annoying to click every + sign to
>> open
>> all nodes. Maybe, there is an easier way that I do not know.
>> 2. When the same drill-down report is partially expanded and I export
>> the
>> report as-it-is to Excel, the exported file has only the partial
>> data.....only the data that was expanded. The other data is never
> exported.
>> What can I do to resolve this ?
>> Please respond.
>>
>|||Jeff, I think your solution is a good one but I have a question for you.
What do you mean that a round trip would be required each time?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:edWDORJ2EHA.1124@.tk2msftngp13.phx.gbl...
> Hmmmm... did you miss my post? There is also an answer to your repost.
> Here was my suggestion:
> You can add logic to the Visibility property of each collapable item on
the
> report and link it to a report parameter. This solution would require a
> round trip to the server each time. Others might have additional
> suggestions...
> Cheers,
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "DC" <dc@.discussions.microsoft.com> wrote in message
> news:O6td5kI2EHA.2112@.TK2MSFTNGP15.phx.gbl...
> >I have not received any response on this yet. Can somebody help ?
> >
> > "DC" <dc@.discussions.microsoft.com> wrote in message
> > news:eAo4xY91EHA.1192@.tk2msftngp13.phx.gbl...
> >> 1. Is there a way to Expand All nodes or Collapse All Nodes in a
> > drill-down
> >> report designed with RS ? I find it annoying to click every + sign to
> >> open
> >> all nodes. Maybe, there is an easier way that I do not know.
> >>
> >> 2. When the same drill-down report is partially expanded and I export
> >> the
> >> report as-it-is to Excel, the exported file has only the partial
> >> data.....only the data that was expanded. The other data is never
> > exported.
> >> What can I do to resolve this ?
> >>
> >> Please respond.
> >>
> >>
> >
> >
>|||If visibility was tied to a report parameter, it would require a postback or
click on a link to change the parameter value.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uezBCzJ2EHA.3376@.TK2MSFTNGP12.phx.gbl...
> Jeff, I think your solution is a good one but I have a question for you.
> What do you mean that a round trip would be required each time?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:edWDORJ2EHA.1124@.tk2msftngp13.phx.gbl...
>> Hmmmm... did you miss my post? There is also an answer to your repost.
>> Here was my suggestion:
>> You can add logic to the Visibility property of each collapable item on
> the
>> report and link it to a report parameter. This solution would require a
>> round trip to the server each time. Others might have additional
>> suggestions...
>> Cheers,
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "DC" <dc@.discussions.microsoft.com> wrote in message
>> news:O6td5kI2EHA.2112@.TK2MSFTNGP15.phx.gbl...
>> >I have not received any response on this yet. Can somebody help ?
>> >
>> > "DC" <dc@.discussions.microsoft.com> wrote in message
>> > news:eAo4xY91EHA.1192@.tk2msftngp13.phx.gbl...
>> >> 1. Is there a way to Expand All nodes or Collapse All Nodes in a
>> > drill-down
>> >> report designed with RS ? I find it annoying to click every + sign to
>> >> open
>> >> all nodes. Maybe, there is an easier way that I do not know.
>> >>
>> >> 2. When the same drill-down report is partially expanded and I export
>> >> the
>> >> report as-it-is to Excel, the exported file has only the partial
>> >> data.....only the data that was expanded. The other data is never
>> > exported.
>> >> What can I do to resolve this ?
>> >>
>> >> Please respond.
>> >>
>> >>
>> >
>> >
>>
>