I have a text object which I put on the Page Footer. The Page Footer height is about 1/2 in.
Somewhere in the report, I have a formula that will set a variable to numeric value 1 depending on a specified
Initially, this numeric variable is set to 0. When this variable's value is set to 1, I wanted to suppress
this Page Footer section.
The detail section is printing on multi-column (4 columns actually) format is down then across.
Previously, I have set this Page Footer section to hide (suppress) and previewing the report will
show that all data will fit on a single page.
When I did the things I mentioned above, I noticed that when the Page Footer section is conditionally
suppressed (because the numeric variable is set to 1), few lines on the detail section is displaying
on page 2. It should be on one page only and that the suppress Page Footer section spaces should be occupied
by the rest of the detail lines to make it a one-page report.
It seems that conditionally suppressing a Page Footer section, the allocated space (1/2 in) will still be
there and will not give way for the rest of the detail section lines...it's like being constantly allocated.
I want that the detail lines will only spill over to the next page in the event the numeric variable is
set to 0 and if 1, all should fit on 1 page only. Right now, it's not doing this.
There is any settings, I need to do?
Please advice possible solution(s) to this problem
The report will display a border of 1/2 in on all sides...this is a constant. The Page Footer section is inside
the buttom border.
I'm using crystal reports 8.5 without any service packs installed and MSSQL 2000 server.