I have a query which is supposed to bring all data for one day (about 5,000 rows) and I have 44 other queries obtain and convert flags into meaningful data with values - each query is 1 row in the report. Total rows including headers are 45. When I run the report in html (with rows set to 50) it runs in 7 minutes when I run it in pdf it errors out after 30 minutes with a timeout on the database (Oracle). How can I retrieve all rows at once and build from there as a pdf without it going back several times to the database? I need a professional printed report of one page and a html print doesn't cut it.
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Retrieve all data at once for a PDF Report
- Thread starter kbeck1
- Start date
Similar threads
