janemcs123
Active Member
I have written a custom report which is causing me some problems. I keep getting odd blank sections appearing. They seem to be completely random, and do not occur at regular intervals.
The report in question is a columnar report. The driver section runs over business view V00060 (just F0006 table). It prints the detail (MCU), and there are also level breaks for Business Unit Subsequent (MCUS) and cat code 22 (RP22). The level breaks are also columnar sections. Within the detail section, there are calls to a couple of conditional sections, which run over the F03B11 and F0902 tables. These sections are hidden, and the main purpose is to return totalled values. The conditional sections are set to non-visible. Any zero rows are supressed.
When the report runs, all the calculations are fine, and for example pages 1-6 will print perfectly, but then on page 7 there will be a huge gap between the detail section and the level break footer for MCUS. I hope some of that makes sense.
I have:
1) checked the page print layout for all versions and the report template - all are set to A4 landscape.
2) check the properties on all the hidden sections to make sure they are hidden, and conditional.
3) Commented out the 'supress section write' statement for zero rows. Strangely this seemed to change where the blank sections were appearing, but did not do anything else.
The question really is, has anyone experienced anything like this, or are there any settings I should be checking which I may have missed? Any suggestions gratefully received.
Thanks,
Jane.
Xe SP22
Oracle 8.1
The report in question is a columnar report. The driver section runs over business view V00060 (just F0006 table). It prints the detail (MCU), and there are also level breaks for Business Unit Subsequent (MCUS) and cat code 22 (RP22). The level breaks are also columnar sections. Within the detail section, there are calls to a couple of conditional sections, which run over the F03B11 and F0902 tables. These sections are hidden, and the main purpose is to return totalled values. The conditional sections are set to non-visible. Any zero rows are supressed.
When the report runs, all the calculations are fine, and for example pages 1-6 will print perfectly, but then on page 7 there will be a huge gap between the detail section and the level break footer for MCUS. I hope some of that makes sense.
I have:
1) checked the page print layout for all versions and the report template - all are set to A4 landscape.
2) check the properties on all the hidden sections to make sure they are hidden, and conditional.
3) Commented out the 'supress section write' statement for zero rows. Strangely this seemed to change where the blank sections were appearing, but did not do anything else.
The question really is, has anyone experienced anything like this, or are there any settings I should be checking which I may have missed? Any suggestions gratefully received.
Thanks,
Jane.
Xe SP22
Oracle 8.1