Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Size limitation for saved report?

Status
Not open for further replies.

HoosHot

Programmer
Jan 16, 2003
41
US
Is there a size limitation for a saved report (when saving data with report)?
Is there a page limitation for a saved report (when saving data with report)?
Is there a record limiation for a saved report (when saving data with report)?

Along these same lines, is there a setting somewhere that limits the number of records that are read into a report? I remember somewhere where you can specify "just bring back the first 100 records." I want to be sure this number is not low (I want to bring back all records).

Thanks :)
mnguyen_va@yahoo.com
 
(I'm re-asking this question since I have not gotten a response...)

Is there a size limitation for a saved report (when saving data with report)?
Is there a page limitation for a saved report (when saving data with report)?
Is there a record limiation for a saved report (when saving data with report)?

Along these same lines, is there a setting somewhere that limits the number of records that are read into a report? I remember somewhere where you can specify "just bring back the first 100 records." I want to be sure this number is not low (I want to bring back all records).

Thanks
mnguyen_va@yahoo.com
 
I've used "saved data" reports with several thousand pages, and several million records. Performance is usually the limiting factor - usually no one really wants a 2,000 page report to page through on the screen, or print.
Regarding size limitations, I haven't run into them, but I would suspect that swap file size, available disk space, and patience are the primary limiting factors.
It is easy to create reports that have millions of records/thousands of pages for testing purposes - pick a table, add another instance of it, and make the join <> instead of =. Repeat if necessary...
Malcolm
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top