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.