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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making the report footer not visible 3
Report Detail - How do I either anchor Lines or box 4
Condition to show the details area 1
Display/hide totals 3
Report Details 2
Hide Field on Subreport 4
Sub report expands even though Can Grow is no 3
MoveLayout and line feed question 6

Back
Top