OK, I figured some of it out by playing around. I didn't realize there were
visibility properties all over the place (row level, group level, textbox
level...) so I found the right combination to get the results I needed.
Now the two remaining issues are:
1) I want to supress the values in the group header cells when the user
clicks the (+) for that group header, because I am displaying the totals in
the group footer. When I choose to toggle those cells, they completely blank
out including border lines, which I want to keep.
2) Now the default HTML breaks the table into two pages in the browser (I
have "fit to one page if possible" checked). But when I export to PDF,
everything fits on a single page. Why is the HTML breaking it up into two
pages?
[quoted text, click to view] "KoryS" wrote:
> I have a table with 4 grouping levels, both headers and footers. I also have
> each group collapsed using the visibility/toggle functionality. But when
> they are all collapsed, except for the first group, I have the totals
> appearing at the group header level. Now when the user expands the first
> level and makes the second group level visible, I toggle the footer for the
> first grouping to see the total at the bottom of the group, but now I have a
> total both on the top (header) and bottom (footer) of this group. I thought
> the simple solution would be to toggle the text boxes in the header row as
> well, but when I do this everything in those cells disappear, not just the
> totals... in other words, where I had used borders and shading, everything
> goes white and no borders, etc. are shown. I would like to just remove the
> values in those text boxes, not the other formatting. Is that possible?
>
> Also, when I set my paper size as 11.5X8 (landscape) and have all of my
> groups collapsed initially, in HTML it separates it into two pages even
> though the table is only about two inches high when collapsed. I have to set
> my paper size to 11.5X12 before the HTML shows up correctly. Doesn't the
> paper size only come into play when you are rendering to PDF or another print
> format other than HTML? I've checked my group and other control settings and
> I can't find anywhere where I have "page break after" or "before" and I even
> stuck my table region in a rectangle thinking that would help, but it didn't.
>
>
> Thanks to anyone who might have some answers!
>
