Focal Point
large report - takes a long time on the browser.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9771057412

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.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
February 23, 2007, 12:08 PM
RichH
Hi 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


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012
February 23, 2007, 12:09 PM
David Hall
The 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!


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.