Wednesday, March 7, 2012
Expanding/Collapsing Dimensions in a Matrix
I have a report that uses data from an MDX query. The result appears in a
drill down format in a Matrix. The report works fine when we click on +/-
buttons. Now, I am displaying the report in a Report Viewer on a web page. On
the same page I have a button, say "Expand All". On click of this button, the
report should appear completely expanded till the last level in the drill
down.
How can I achieve this effect? I havent got hold of any expressions that may
be useful for expanding all sublevels at one go. Please suggest.
Thanks
RishitThe way to access attachments depends on what you are using as your
newsreader.
Note: Some web-based newsreaders don't support attachments at all. If
you're using one of those, you should switch to a different one. The
simplest approach is to use Outlook Express instead.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"jo st charles" <jostcharles@.discussions.microsoft.com> wrote in message
news:3FAB1231-AE28-4F92-AFE1-5E575E604D92@.microsoft.com...
> Please tell me how I can access the attachment. Thank you.
> "Chris Hays [MSFT]" wrote:
> > Attached is an example (from John Miller) of how to do this in a Table.
The
> > approach is similar for a matrix.
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach of
> > children under 3.
> > "Rishit" <Rishit@.discussions.microsoft.com> wrote in message
> > news:D6A65970-A3BB-4CE5-AF7F-8ED93508DA05@.microsoft.com...
> > > Hi MSFT,
> > > I have a report that uses data from an MDX query. The result appears
in a
> > > drill down format in a Matrix. The report works fine when we click on
+/-
> > > buttons. Now, I am displaying the report in a Report Viewer on a web
page.
> > On
> > > the same page I have a button, say "Expand All". On click of this
button,
> > the
> > > report should appear completely expanded till the last level in the
drill
> > > down.
> > >
> > > How can I achieve this effect? I havent got hold of any expressions
that
> > may
> > > be useful for expanding all sublevels at one go. Please suggest.
> > >
> > > Thanks
> > > Rishit
> >
> >
> >
Expand/Collapse all buttons in reports
We just wonder if there is an easy way to incorporate "expand all-collapse all" options in the reports we chose to drill down.
Starting with a collapsed report is lovely but as the data get more it may be easier for some to see it all expanded.
Thanking you in advance,
Dimitris, Athens, GreeceThe closest you can get is to add a boolean report parameter and use that parameter in expressions to determine the initial state of all your expand/collapse items.
-- Robert|||
For the hopeful benefit of anyone else trying to get the InitialToggleState property to behave properly when setting it via an expression: From a posting by Chris Hays elsewhere, we learn that "The values aren't the strings 'Collapsed' and 'Expanded', they're True and False (Boolean)."
So, the conditional to set the InitialToggleState property won't look like this (for a String input parameter):
=IIF(Parameters!HideDetails.Value = "Yes", "Collapsed", "Expanded")
Rather, do it this way:
=IIF(Parameters!HideDetails.Value = "Yes", True, False)
Expand/Collapse all buttons in reports
We just wonder if there is an easy way to incorporate "expand all-collapse all" options in the reports we chose to drill down.
Starting with a collapsed report is lovely but as the data get more it may be easier for some to see it all expanded.
Thanking you in advance,
Dimitris, Athens, GreeceThe closest you can get is to add a boolean report parameter and use that parameter in expressions to determine the initial state of all your expand/collapse items.
-- Robert|||
For the hopeful benefit of anyone else trying to get the InitialToggleState property to behave properly when setting it via an expression: From a posting by Chris Hays elsewhere, we learn that "The values aren't the strings 'Collapsed' and 'Expanded', they're True and False (Boolean)."
So, the conditional to set the InitialToggleState property won't look like this (for a String input parameter):
=IIF(Parameters!HideDetails.Value = "Yes", "Collapsed", "Expanded")
Rather, do it this way:
=IIF(Parameters!HideDetails.Value = "Yes", True, False)
Sunday, February 26, 2012
Expand All Collapse All
function fine, and when the report is displayed the user can click on the +
signs to expand a group. I would like to add the option for the user to be
able to Expand All or Collapse all. Currently they have to click on every +
sign to Expand All. I have not found out how to do this in SSRS. Any help
with this would be greatly appreciated.
Thanks.
--
ChrisYou can have expand all by setting the toggle item to a level above the
parent group, or perhaps to the lable at the top of the tabel.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Chris" wrote:
> I'm using SSRS 2005 and I can create report that use the enable drill down
> function fine, and when the report is displayed the user can click on the +
> signs to expand a group. I would like to add the option for the user to be
> able to Expand All or Collapse all. Currently they have to click on every +
> sign to Expand All. I have not found out how to do this in SSRS. Any help
> with this would be greatly appreciated.
> Thanks.
> --
> Chris|||Thank you Wayne I will try that.
--
Chris
"Wayne Snyder" wrote:
> You can have expand all by setting the toggle item to a level above the
> parent group, or perhaps to the lable at the top of the tabel.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Chris" wrote:
> > I'm using SSRS 2005 and I can create report that use the enable drill down
> > function fine, and when the report is displayed the user can click on the +
> > signs to expand a group. I would like to add the option for the user to be
> > able to Expand All or Collapse all. Currently they have to click on every +
> > sign to Expand All. I have not found out how to do this in SSRS. Any help
> > with this would be greatly appreciated.
> >
> > Thanks.
> >
> > --
> > Chris|||Thank you very much! It worked just fine.
--
Chris
"Chris" wrote:
> Thank you Wayne I will try that.
> --
> Chris
>
> "Wayne Snyder" wrote:
> > You can have expand all by setting the toggle item to a level above the
> > parent group, or perhaps to the lable at the top of the tabel.
> >
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> >
> >
> > "Chris" wrote:
> >
> > > I'm using SSRS 2005 and I can create report that use the enable drill down
> > > function fine, and when the report is displayed the user can click on the +
> > > signs to expand a group. I would like to add the option for the user to be
> > > able to Expand All or Collapse all. Currently they have to click on every +
> > > sign to Expand All. I have not found out how to do this in SSRS. Any help
> > > with this would be greatly appreciated.
> > >
> > > Thanks.
> > >
> > > --
> > > Chris