Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Maximum No fo records in a Page Post Reply Post New Topic
Author Message
karthikkjm
Newbie
Newbie
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 21
Quote karthikkjm Replybullet Topic: Maximum No fo records in a Page
     Posted: 05 Jun 2011 at 10:47pm
my report had a details sections. in my report i restricted maximum no of records as 30/Page, using the formula on New Page After if Remainder (RecordNumber, 30) = 0 then true else false.
But now i added a group, now i need to display the group name & details. but now also i need to display only 30 lines (records + group headers) per page.
Please reply me....very urgent...

thanking You,
Karthik K

karthik
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 05 Jun 2011 at 11:19pm
You can use a Glbal Variable in your formula.
Increment the Variable by one for each line.
Something like this
Var:= Var + 1
 
Add the farmula to your detail lines as well as the group lines.
Change you formula in the New Page to use the formula you just created instead of the record number.
 
Remember to reset the global variable in the page header.
 
Should do the trick.
 
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
karthikkjm
Newbie
Newbie
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 21
Quote karthikkjm Replybullet Posted: 06 Jun 2011 at 2:01am
thank you, its works fine....
I added one more line on PageHeader & Details Section the function.

Pageheader Formula
WhilePrintingRecords;
global NumberVar LineNo :=0;

GroupHeader & Details Section Formula
WhilePrintingRecords;
global NumberVar LineNo :=LineNo + 1;

Thank U...
Keep Helping Peoples...
karthik
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 06 Jun 2011 at 2:05am
You're welcome
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum