Symptom
- Add a Cross-Tab in Group Footer and set conditional suppress of this Cross-Tab
- Extra blank space shows in Cross-Tab even conditional suppressed is setssdsd
Environment
- Crystal Reports 2008 SP7 (CR 2008 SP7)
Reproducing the Issue
- Create a CR report based on e-fashion universe and add some objects (For example: Year, Month, Sales revenue).
- Insert Group into the CR report grouped by Year.
- Insert a Cross-Tab into the Group Footer.
- Select the Cross-Tab, right click on it and select Cross-Tab Expert. Cross-Tab Expert window pops up.
- In Cross-Tab tab as follows:
Rows: Year; Columns: Month; Summarized Fields: Sales revenue. - In Customize Style tab, check Suppress Column Grand Totals.
- Click OK button to close the Cross-Tab Expert window, will get followings.
- Preview and there is extra blank space output between each Group Footer.
Cause
This is by-design.
When conditional suppress is set, the object is suppressed and the place is blank but CR will always reserve the space for the biggest section when performing any conditional suppress on these Group Footer sections.
Section height is the height of section in CR Design mode. It can grow if the content height is large, but it can’t shrink by itself;
In this case, section height is equal to 3 table lines. So even the total is suppressed, the space is still kept.
Keywords
CR, Crystal Reports, Crystal, Crosstab, Cross-Tabs, suppress, cannot, can not, show, display, extra, output, blank, space, height, section height, group footer height, group, row, setting , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem