IO_Dork
asked on
crosstab grand totals - suppress some, not all
Is there a way to suppress certain column grand totals of a crosstab. I know there is a function to suppress grand totals in the Cross-Tab Expert > customize style area, but that is for suppressing the entire column grand total section.
I also know that I can manual suppress each field in the grand total section, but the problem with that is that I still takes up the same vertical space in the grand total section...that section does not vertically collapse in size as you suppress each grand total.
I also know that I can manual suppress each field in the grand total section, but the problem with that is that I still takes up the same vertical space in the grand total section...that section does not vertically collapse in size as you suppress each grand total.
ASKER
the grand totals circled in red...those are the elements that I want to suppress. And when they are, the Total section should collapse vertically so that it auto fits to just the one remaining grand total line.
Doc1.pdf
Doc1.pdf
I created a quick crosstab that was similar to yours. I couldn't get those totals to shrink. or go away.
mlmcc
mlmcc
ASKER
OK, so I guess it's control that Crystal reports does not provide.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc