Showing posts with label level. Show all posts
Showing posts with label level. Show all posts

Wednesday, March 7, 2012

Expanding All SubQuery Nodes In Reports

Hi Everybody,

I've got a report that builds out top level data and adds the plus symbol (+) for collapse/expand next to each of the rows for me to display a detail level tied to that record.

The problem is when we do an export or print, it only applies to the top level instead of all of the detailed information.

Is there a way to automatically expand all tree-nodes in a report for these subqueries?

Thanks in advance.

Best Regards,

Justin

Gentle bump... Anybody know how to do this? I just want to be able to expand all child nodes of a record, either automatically or programatically...

Thanks!

|||

Hiya,

You can tell the report to always expand, or, as I did, always closed and added a boolean parameter called "Show All" to the report. I gave it a default value of False, and set the initial visiblity property of the group to an expression to "=Parameters!ShowAll.Value = True". all the user has to do is click the check box marked "Show All" and refresh the report

|||

Thanks for the info!

I'm digging through the report designer, but I can't find anywhere to 'tell the report to always expand'.

Mind providing me with further insight into this? Specifically, where in the report designer do I set this property?

Thanks again,

Justin

|||

Looking at the report, right-click on the group number on the left hand side and choose edit group (or right click in your report and choose select table 1 (or similar if matrix) click on the border of the table or matrix and choose properties. In groups, choose your group/ edit. Under visibility you can see the options for initial visibility.

That is in visual studio - are you using something else?

HTH

|||

Thanks again for your quick reply - this forum is a life saver!

I've got the visibility dialog up, but I'm not sure how to change it to 'Expand All'. Currently the Visibility radio button is set to 'Visible'.

Is there an expression, or something else that I should be using to tell it to Expand All child nodes?

Regards,

Justin

|||You need to look at the child group properties. Visibility depending on another item is always on the child node.

Expanding All SubQuery Nodes In Reports

Hi Everybody,

I've got a report that builds out top level data and adds the plus symbol (+) for collapse/expand next to each of the rows for me to display a detail level tied to that record.

The problem is when we do an export or print, it only applies to the top level instead of all of the detailed information.

Is there a way to automatically expand all tree-nodes in a report for these subqueries?

Thanks in advance.

Best Regards,

Justin

Gentle bump... Anybody know how to do this? I just want to be able to expand all child nodes of a record, either automatically or programatically...

Thanks!

|||

Hiya,

You can tell the report to always expand, or, as I did, always closed and added a boolean parameter called "Show All" to the report. I gave it a default value of False, and set the initial visiblity property of the group to an expression to "=Parameters!ShowAll.Value = True". all the user has to do is click the check box marked "Show All" and refresh the report

|||

Thanks for the info!

I'm digging through the report designer, but I can't find anywhere to 'tell the report to always expand'.

Mind providing me with further insight into this? Specifically, where in the report designer do I set this property?

Thanks again,

Justin

|||

Looking at the report, right-click on the group number on the left hand side and choose edit group (or right click in your report and choose select table 1 (or similar if matrix) click on the border of the table or matrix and choose properties. In groups, choose your group/ edit. Under visibility you can see the options for initial visibility.

That is in visual studio - are you using something else?

HTH

|||

Thanks again for your quick reply - this forum is a life saver!

I've got the visibility dialog up, but I'm not sure how to change it to 'Expand All'. Currently the Visibility radio button is set to 'Visible'.

Is there an expression, or something else that I should be using to tell it to Expand All child nodes?

Regards,

Justin

|||You need to look at the child group properties. Visibility depending on another item is always on the child node.

Expanding All SubQuery Nodes In Reports

Hi Everybody,

I've got a report that builds out top level data and adds the plus symbol (+) for collapse/expand next to each of the rows for me to display a detail level tied to that record.

The problem is when we do an export or print, it only applies to the top level instead of all of the detailed information.

Is there a way to automatically expand all tree-nodes in a report for these subqueries?

Thanks in advance.

Best Regards,

Justin

Gentle bump... Anybody know how to do this? I just want to be able to expand all child nodes of a record, either automatically or programatically...

Thanks!

|||

Hiya,

You can tell the report to always expand, or, as I did, always closed and added a boolean parameter called "Show All" to the report. I gave it a default value of False, and set the initial visiblity property of the group to an expression to "=Parameters!ShowAll.Value = True". all the user has to do is click the check box marked "Show All" and refresh the report

|||

Thanks for the info!

I'm digging through the report designer, but I can't find anywhere to 'tell the report to always expand'.

Mind providing me with further insight into this? Specifically, where in the report designer do I set this property?

Thanks again,

Justin

|||

Looking at the report, right-click on the group number on the left hand side and choose edit group (or right click in your report and choose select table 1 (or similar if matrix) click on the border of the table or matrix and choose properties. In groups, choose your group/ edit. Under visibility you can see the options for initial visibility.

That is in visual studio - are you using something else?

HTH

|||

Thanks again for your quick reply - this forum is a life saver!

I've got the visibility dialog up, but I'm not sure how to change it to 'Expand All'. Currently the Visibility radio button is set to 'Visible'.

Is there an expression, or something else that I should be using to tell it to Expand All child nodes?

Regards,

Justin

|||You need to look at the child group properties. Visibility depending on another item is always on the child node.

Sunday, February 26, 2012

Expand All\Collapse All

I have a table where i used almost 7 groups with toggle on each level ...
so by default only one row shows up with a + - user clicks on it 2nd row
shows up like that 7 groups and then they can c the rows.
But is there anyway that i can use an option of Expand All in one click ?
like have a button next to the table and when the user clicks on it - all the
rows will be expanded without the user clicking so many times to c the final
result '
thanksRP,
Use a parameter.
In the Visibility tab of the groups properties, make the Visible
property and expression based around a parameter.
Search this newsgroup for more detail. It's a common request.
Chris
RP wrote:
> I have a table where i used almost 7 groups with toggle on each level
> ... so by default only one row shows up with a + - user clicks on
> it 2nd row shows up like that 7 groups and then they can c the rows.
> But is there anyway that i can use an option of Expand All in one
> click ? like have a button next to the table and when the user
> clicks on it - all the rows will be expanded without the user
> clicking so many times to c the final result '
> thanks|||Thanks for the reply chris, I searched the newsgroup - but the ?'s were
mostly on individaul levels.
My problem is once, the user click the Expand all button, i want all the
levels in all the groups to be expanded.
ANyways i will try the parameter.
Thanks
"Chris McGuigan" wrote:
> RP,
> Use a parameter.
> In the Visibility tab of the groups properties, make the Visible
> property and expression based around a parameter.
> Search this newsgroup for more detail. It's a common request.
> Chris
>
> RP wrote:
> > I have a table where i used almost 7 groups with toggle on each level
> > ... so by default only one row shows up with a + - user clicks on
> > it 2nd row shows up like that 7 groups and then they can c the rows.
> > But is there anyway that i can use an option of Expand All in one
> > click ? like have a button next to the table and when the user
> > clicks on it - all the rows will be expanded without the user
> > clicking so many times to c the final result '
> >
> > thanks
>|||RP,
If you set the property mentioned in the same way for each level, you
should get what you've asked for.
You could set them to toggle from a heading cell also with the toggle
item property.
Chris
RP wrote:
> Thanks for the reply chris, I searched the newsgroup - but the ?'s
> were mostly on individaul levels.
> My problem is once, the user click the Expand all button, i want all
> the levels in all the groups to be expanded.
> ANyways i will try the parameter.
> Thanks
>
> "Chris McGuigan" wrote:
> > RP,
> > Use a parameter.
> > In the Visibility tab of the groups properties, make the Visible
> > property and expression based around a parameter.
> >
> > Search this newsgroup for more detail. It's a common request.
> >
> > Chris
> >
> >
> > RP wrote:
> >
> > > I have a table where i used almost 7 groups with toggle on each
> > > level ... so by default only one row shows up with a + - user
> > > clicks on it 2nd row shows up like that 7 groups and then they
> > > can c the rows. But is there anyway that i can use an option of
> > > Expand All in one click ? like have a button next to the table
> > > and when the user clicks on it - all the rows will be expanded
> > > without the user clicking so many times to c the final result '
> > >
> > > thanks
> >
> >