- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Sorry to keep revisiting this thread but after much wasted time I figure asking for help is the best thing to do.
My table has one header, six sections each with a variable number of body rows and a footer for subtotals, and after the sections, a footer for grand totals.
It looks like this:
HEADER FOR THE TABLE
Section1 -body row 1
body row 2
body row 3
SECTION 1 FOOTER
Section2 -body row1
body row2
body row3
body row4
SECTION 2 Footer
FOOTER FOR WHOLE TABLE
I would like to be able to have sections appear only if necessary, and the trigger would be a checkbox in a hidden subform.
I can get individual body rows within the section and the section footer to hide, but I can't get the section as a whole to hide in one fell swoop.
In fact the only presence property I see for the sections is Visible, Visible (Screen Only), and Visible (Print Only). The rest are grayed out. The screenshot below shows the issue.
Is this possible? I mean to hide sections (or groups of rows), rather than just single rows. If so what should I be looking for or doing?
Another question I have is this. Depending on the data, the sections could have more rows than could fit on a single page. What is the best way to deal with this, so that the table header appears at the top of each page, and the table footer only on the last page? It would be preferable to do this in a way
so that if a section was going to end up spanning two pages, the whole section would instead go onto the next page rather than be split.
Thanks.
Harry.
Message was edited by: HarryOhm I tried the "insert image" function for the screenshot but for whatever reason it does not work.
Views
Replies
Total Likes