cancel
Showing results for 
Search instead for 
Did you mean: 

Records Set Up

nsandee
Participant
0 Kudos

Hello All,

I have a requirement where i need to "Print headings on all pages and print 50 lines per page in each report excluding heading lines".

Please let me know how can we do this.

Best Regards

Sandeep

Accepted Solutions (0)

Answers (2)

Answers (2)

abhilash_kumar
Active Contributor
0 Kudos

Hi Sandeep,

To print 50 lines on a page, you can even try this:

Right-click the Blue area beside the Details Section > Select Section Expert > Go to the Paging Tab > Click the formula button beside 'End of Section' and use this code:

RecordNumber Mod 50 = 0

-Abhilash

nsandee
Participant
0 Kudos

Hello Sastry & Abhi,

Thank you for the inputs.

Sorry, we are using CR XI R2 and i dont see any paging tab

Best Regards

Sandeep

abhilash_kumar
Active Contributor
0 Kudos

Could you paste a screenshot of the Section Expert for the Details Section please?

-Abhilash

nsandee
Participant
0 Kudos

Hello Abhi,

Please find the screen shot.


Best Regards

Sandeep

former_member205840
Active Contributor
0 Kudos

Hi

In the screen capture there is a option called New Page After / New Page before.. write your formula in that option formula editor

Thanks,

Sastry

nsandee
Participant
0 Kudos

Hi Sastry,

Do i need to write formula both in New Page After & New page before ?

Best Regards

Sandeep

abhilash_kumar
Active Contributor
0 Kudos

Just the 'New Page After'.

-Abhilash

nsandee
Participant
0 Kudos

Hello Abhi & Sastry,

I tried the formula suggested by you

1. RecordNumber Mod 50 = 0 and i tried increasing the value to test whether it is working or not

RecordNumber Mod 55 = 0 but there is no change in the records

1.    2.  Whileprintingrecords;

Numbervar x;

If x>50 Then true else false.   

Also tried

and i tried increasing the value to test whether it is working or not

If x>55 Then true else false

but there is no change in the records

Best Regards

Sandeep

abhilash_kumar
Active Contributor
0 Kudos

Try reducing the number to 20 and see if you see a page break after 20 detail lines.

Perhaps, your page is too small to fit 50 records.

-Abhilash

nsandee
Participant
0 Kudos

Hi Abhi,

I tried reducing the number to 20 and i am surprised that there is no change in the records though i implemented the same formula in New Page before even.

We have set page type - legal as suggested by Business\Senior management in our company.

File --> Page Setup -- > Paper Size -- > Legal

Why the behaviour is like this?  Any alternative method on how to proceed on this? Dont we have any work around in this old version (CR XI R2)

Best Regards

Sandeep

abhilash_kumar
Active Contributor
0 Kudos

After removing the formula under 'New Page After', could you manually count how many lines display on each page?

-Abhilash

nsandee
Participant
0 Kudos

it is coming around 33

Best Regards

Sandeep

abhilash_kumar
Active Contributor
0 Kudos

Are you counting the Detail lines or the Group Lines too?

Anyway, see if this works:

1) Go to the New Page After formula for the Details Section and use this code:

numbervar x;

x := x + 1;

x = 20;

2) Create a new formula from the Field Explorer with the code below and place this field on the Page Header:

whileprintingrecords;

numbervar x := 0;

-Abhilash

nsandee
Participant
0 Kudos

Hi Abhi,

I am counting detail & group footer 5 in the screen shot. If i include Group header, then total count would be around 45 but we need excluding group header.

Formule is working fine if i try to reduce to 20 but total count doesnt match to the scenario "print 50 lines per page in each report excluding heading lines".

numbervar x;

x := x + 1;

x = 20;

Best Regards

sandeep

abhilash_kumar
Active Contributor
0 Kudos

You mean 50 lines of Details + Group Footer 5 on a single page?

You would also need a similar formula on the Group Footer to increment the value of x then.

-Abhilash

former_member205840
Active Contributor
0 Kudos

Hi Sandeep,

To print heading on all pages, move all your headings into Page Header.

To print 50 lines per page..

Create following formulas :

Whileprintingrecords;

Numbervar x:=5  // here 5 is nothing but number of heading lines and place it in Page header

Whileprintingrecords;

Numbervar x:=x+1  // place this formula in details and groups.

Go in Section expert detail / groups and go in Paging tab and give following condition.

Whileprintingrecords;

Numbervar x;

If x>50 Then true else false

Thanks,

Sastry