collapse/expand

[AccessMan]

Is there any way to have report content be collapsed and expanded based on
user mouse actions? I have a report with 10 grouping levels, and I would
like the user to have the option of collapsing and expanding them.

Thanks!

 

[Marshall Barton]

Is there any way to have report content be collapsed and expanded based on
user mouse actions? I have a report with 10 grouping levels, and I would
like the user to have the option of collapsing and expanding them.

No. A report displayed on the screen is just a visual
representation of what it would look like when printed to
paper. There are no interactions with the mouse.

The normal approach is to close the report, change a form
control (to indicate a different formatting) and reopen the
report.

If you feel adventurous, you might be able to switch between
the report preview and the form (or a custom tool bar) and
reset the report's filter or something to cause it to
reprocess its data. I haven't tried this in any way similar
to what you want so you would be mostly on your own.

 

[Marshall Barton]

No. A report displayed on the screen is just a visual
representation of what it would look like when printed to
paper. There are no interactions with the mouse.

The normal approach is to close the report, change a form
control (to indicate a different formatting) and reopen the
report.

If you feel adventurous, you might be able to switch between
the report preview and the form (or a custom tool bar) and
reset the report's filter or something to cause it to
reprocess its data. I haven't tried this in any way similar
to what you want so you would be mostly on your own.

I had some spare time yesterday so I gave this kind of thing
a try. Mild surprise, but it worked in my test cases.

The VBA code in the report is at an advanced level, but like
most things, not too difficult when you know how. If you
feel adventurous, I can probably provide some assistance
now.