Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Line number restriction in Page Header Post Reply Post New Topic
Author Message
sidiqbismi
Newbie
Newbie


Joined: 15 Mar 2010
Location: India
Online Status: Offline
Posts: 11
Quote sidiqbismi Replybullet Topic: Line number restriction in Page Header
     Posted: 16 Mar 2010 at 7:06pm

Hi,

I am using Crystal report XI. I am new to crystal report.

I am in need to restrict the number of line in Page header.

For Example, if the record set having 20 records then it would be displayed only 10 records in the first page header then the remaining 10 will displayed on the next page header. Can any one help me to resolve this?

Thanks for your help

 

 
IP IP Logged
razzak
Newbie
Newbie
Avatar

Joined: 03 Mar 2010
Location: India
Online Status: Offline
Posts: 34
Quote razzak Replybullet Posted: 16 Mar 2010 at 11:30pm
you can solve your problem through SQL .
create one temp table and 10 record for this ten record insert ID for these 10 reocrd by using cursor or loop.
 
e.g
my output will look as
 
ID  product_id
1  100
1  101
1  102 
1  103
1  104 
1  105
1  106
1  107 
1  108
1  109
2  110
2  111 
2  112 
2  113
 
 
group on ID in report.
 
this may help you.
 
 
Razzak Sayyed
IP IP Logged
sidiqbismi
Newbie
Newbie


Joined: 15 Mar 2010
Location: India
Online Status: Offline
Posts: 11
Quote sidiqbismi Replybullet Posted: 17 Mar 2010 at 6:15am

Thanks for your reply

since i don't have to access database, i am in need to do this at page header level.
is it possible to do this sql operation at CRYSTAL REPORT Design level? or
is there any other way to do this?
Thanks in adcance for your help.


Edited by sidiqbismi - 17 Mar 2010 at 6:19am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 17 Mar 2010 at 7:47am
I have created a command that created a temp table and it appears to work just fine.  I have not tried using cursor or a loop, so that would be a test.  Just be sure to drop the table at the end of the command. 
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.