I have an html report that returns 30,000 rows. Once the query returns the records to the html frame it is very slow to refresh while trying to move up and down the data set. The refresh is so slow it is impossable to use. Any ideas to how correct. I am assuming it is to much data for the frame but wanted to see if any one else has had this problem.

Are you sure the report is completely loaded when paging? I've noticed that with longer ones as the report was still being generated into the html page.

The report appears to be completely loaded. The IE process CPU usage is 0 and the memory has stopped increasing a rest at 634,164 K. Still has the same refreah problems.

Isn't the fact that it returns 30,000 rows the reason why it's unusable? Why not do something about the report design? Internet Explorer or the PC is probably running out of memory. The problem you describe appears to have nothing to do with WebFOCUS.

I realize it is a pc/browser problem. Not a web Focus problem and was querying the group to see if anyone else had experienced the same thing and if so if they were able to over come it by any means. Browser tweak etc. Thanks for your input.

You'll lose a lot of styling, but if 30,000 records for the report are the norm, you may want to try formats WP or EXCEL (not EXL2K as this will still have html tags).

These two formats will return the data without the html tags which are taking a significant amount of memory.

Try the WF web viewer option. Returns a page at a time, search capabilities, etc.

I would discus this with the one who ask for such a report.
30.000 records? 500 pages, if they decide to print it. This is no Information, this is data.
But if you insist, use Darin's suggestion.

Well, I have report that is over 700 pages that our Campus Security Office prints through our production every semester and can run it to a PDF if they want from their dashboard as well. Note I said PDF.

As Darin suggested, use the 'on demand paging' option. If you are in Report Painter then select Report, format and then click on the on damand box, otherwise in Edit type in
ON TABLE SET WEBVIEWER ON. This will bring in the report one page at a time. It will also allow you to do a search, go to the end of report, or to any page in the report.