Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to bring records in batches from DB server Post Reply Post New Topic
Author Message
preethi
Newbie
Newbie


Joined: 07 Sep 2008
Online Status: Offline
Posts: 1
Quote preethi Replybullet Topic: How to bring records in batches from DB server
     Posted: 14 Oct 2009 at 1:55pm
Hi,

I have a report which need to print a lot of data...report has 2000 pages..i am using an oracle stored procedure as data source.

Is there any option in crystal so that when i run the report only the first page data is brought back to the report...and when i click on next page on the navigation bar then it will contact DB server and brings next records?

Thank you..
Preethi.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 15 Oct 2009 at 6:16am
Sorry, but no.  Think the way that Crystal has to.  What if there is a grouping, and the first and last record of a dataset are in the same group, how can it display the group unless it has read ALL the data, how does it know which data is on the first page or even how long the first page is until has read all the data and determined the groups and the suppressions and the total lines etc.
 
When you think about it, Crystal needs to read all the data and run the calculations etc, and if you have read all the data and done all the work, you might as well as display it all.
 
HTH
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