How to make an expandable table to hide/show details of a report?

  • Thread starter Thread starter BY
  • Start date Start date
B

BY

Is it possible to make a table report with an expandable tab that hide or
show the details? Thank you.
Brad
 
BY said:
Is it possible to make a table report with an expandable tab that hide or
show the details?
Click to expand...


No. Reports are printed to sheets of paper where buttons,
tabs, etc have no effect. Any other output of a report
(Preview, PDF, etc) are just electronic representations of
the paper so that is not an alternative.

In general, you need to close the report and reopen it with
some other option that hides the details.

The one trick I know of is if you use a custom menu/tool bar
(or even a form) button, you can get a report in preview
mode to redo itself by setting its OrderBy (or Filter)
property:
'show/hide detail
Reports!thereport.Section(0).Visible = <some condition>
'redo report without closing and reopening
.OrderBy = """xxx"""
.OrderByOn = True
 
Back
Top