February 23, 2007, 12:05 PM
Jason K.large report - takes a long time on the browser.
Hello!
I have a large html report that displays around 36,000 records and it seems to take minutes to render in the browser. Is there a way to page through this report somehow so the user doesn't have to wait for all the information to load?
I'm fairly new to web focus, I'm sorry if this is an obvious answer.
February 23, 2007, 12:08 PM
RichHHi Jason,
Try SET WEBVIEWER=ON and see if this helps you.
This will download one page of HTML report output to your browser, instead of the entire report.
Rich
February 23, 2007, 12:09 PM
David HallThe problem you are having is due to the way HTML works
You wont see the first line, until it has finished process the entire report.
The best solution for this is to use On Demand Paging. This may be done by
adding the following command to the Focexec:
ON TABLE SET WEBVIEWER ON
Now the entire report will be sent to your browser and can be displayed
page by page through the Web Viewer.
February 26, 2007, 10:46 AM
Jason K.This is very neat functionality! Thank you for the suggestion.
Unfortunately, I would like to maintain the ability for users to have the OLAP control panel at their disposal, enabling the Webviewer with OLAP ON gives this error:
(FOC3250) OLAP AND ON-DEMAND PAGING ARE MUTUALLY EXCLUSIVE.
Any ideas?
Thank You!