on 12-24-2013 6:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.