Hi Experts,
I have a CR on SAP BW query, I view the report through Business Objects Infoview,the issue is after the report is executed, when I click to go to page 2 or any page, its almost takes same time as it takes when it take to execute the report, also when I try to import to excel sheet its taking long time to popup saveas box.
Please let me know how do I tune these issues through Infoview.
Thanks,
R
raghu.1738 (BOB member since 2011-05-19)
How many pages are in your report? Are you using any subreports?
Part of this is just how Crystal works inside BusinessObjects. When you run a report interactively, the system renders one page at a time. So, the first time that you view a page, Crystal has to process it before it can be viewed. If you have any subreports, Crystal has to connect to the database to pull the data for each subreport that is run - for example, if you have a subreport in a details section, Crystal will connect to the database and run the query in the subreport for every record in your report. If you move back to a page that you’ve already seen, it should be fairly quick because the page has been cached and doesn’t have to be reprocessed.
Your export is taking time because Crystal has to process all of the pages of data prior to exporting them. If it is large, it will take a longer time to export. Once again, if you have any subreports, this will also affect how long the export takes.
-Dell
hilfy 
(BOB member since 2007-04-16)