Fix new page after certain rows

[Former Member]

I have a requirement with the below details, I have been working for 1 week, but I was nto able to find a solution,

Query 1:

A report which displays details from the database. For every page there should be no empty space except margins. In details Section row height is fixed (1.3)

For example, report is having 9 rows.

Then for the above mentioned row height all the rows are displayed with the report footer.

If reprot footer is to be dispalyed, then only 9 rows can be placed in details section.

If report footer is not dispalyed, 13 rows should be dispalyed so that empty space wont be there after details section

Suppose report is having 25 rows, how to get the above requirement? At present I gave u201CNew Page Afteru201D value as 9 but empty space is more for first two pages.

Can anyone please help me out from this issue?

Query2:

For me, the below workout to display equal number of rows in all pages is alos not working,

Formula 1:

WhilePrintingRecords;

Global numberVar PageRecCount;

PageRecCount := 0;

Formula 2:

WhilePrintingRecords;

Global numberVar PageRecCount;

PageRecCount := PageRecCount + 1;

Place first formula in the "Page Header" section and second one in the "Detail" section (also suppress those [just to hide])

Now go to Report -> Selection Expert and select Detail section. In the Detail section, find "New Page After" and click the button in front of that ("X + 2" button) and paste following in there.

Global numberVar PageRecCount;

PageRecCount = 10;

For me there is no button in front of "New Page After". Below "New Page After", there are 2 checkboxes and X+2 buttons in formt of those two checkboxex. One is End of Section where i am able to write the above formula, another check box is visible records where i am not able to write the above formula. is is showing an error like 'A number or currency is required".

Thank you.

[Former Member]

I dont know whether i am clear or not.

Actually it is a report which exists in Word format containing Page Header & footer. the number of rows to be displayed are dynamic and row height is fixed.

In one page with page header & report footer, only 9 rows can be placed. If there are 13 rows, then there are 2 problems,

1) if 9 rows are dispalyed per apge means there will be gap in first page as reprot footer doesnt come

2) In second page, if 4 rows are displayed, then remaining 5 rows should be dispalyed with empty (i.e, simailar to a table, empty row to be displayed with border)

[Former Member]

Hi,

I have validated your logic and able to implement, Only you need to write the below logic under New Page Before (X-2)

Global numberVar PageRecCount;

PageRecCount = 10;

Thanks,

Kiran