Skip to Content
author's profile photo Former Member
Former Member

Fix new page after certain rows

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2012 at 08:09 AM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.