Formatting in a Table data region

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!
KoryOK, 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?
"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!
> Kory