BY said:
Is it possible to make a table report with an expandable tab that hide or
show the details?
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
