 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| HTML Report Refresh | Login/Join |
| Member |
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. | ||
|
| Virtuoso |
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. Leah | |||
|
| Member |
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. | |||
|
| Expert |
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. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Member |
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. | |||
|
| Gold member |
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. Windows: WF 7.6.2: SQL Server 2008 R2 | |||
|
| Virtuoso |
Try the WF web viewer option. Returns a page at a time, search capabilities, etc. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Virtuoso |
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.
| |||||||
|
| Virtuoso |
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. Leah | |||
|
| Guru |
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. WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |