AccessMan said:
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.