How to show column header/footer only if details section is displayed?

[bz3x]

Dear community,

I've been struggling with what seems like a simple issue. I have a report with three subreports. When the first subreport has just enough records in the detail section to fill up almost the entire first page, and at the bottom of the first page there's just enough room for the header of the second subreport (but not the details section), that subreport shows only the column header and the column footer but not the data section.

In short: how can I force the second subreport to display the column header and column footer only if the detail section is displayed?

I've tried setting the "Print when" of subreport's column footer to !$V{sumTotal}.isNaN() (sumTotal is a variable I use to show data in the footer). That works for the footer but the subreport header remains. And I can't use the same trick as with the footer because the sumTotal variable isn't set yet.

The issue is clearer in the attached report.

Thanks for any pointers or solutions!

[bz3x]

Correction: column header and column footer were not the appropriate bands for this report. I'm now using "title" and "last page footer".

 

The main question now is: How to force a page break when there is only space for the title but not for any records, so that the whole subreport starts on a new page?

[oesina]

Hi bz3x,

try to make the size of your subreport image with something like 200pixel Height, so that will become the minimum size to start the band and the subreport object on the same page. So there's onlly less than 200 pixels on the bottom of the page, it will force to start from next page.

Hope it helps,

Olga

[KGZ]

Hi bz3x,

You can use the variable REPORT_COUNT in the "print when" expression like this :  !$V{REPORT_COUNT}==0

KGZ

[bz3x]

YES! Thank you Olga.