Sunday, February 26, 2012

Expand All Collapse All

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.
--
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

No comments:

Post a Comment