 |
|||||
|
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 |
| [CLOSED] LIMITING REPORT SIZE | Login/Join |
| Member |
I'm new to WebFocus/ReportCaster and have been handed an undocumented older version of WF, ReportCaster and the BI Dashboard. We are having an issue with user's requesting reports that are huge (10+MB) and hosing our server resources and ultimately dragging down disk space. I need the quickest, easiest way to remedy this as apparently original developers did not bake in any rowcount/size limitations into report requests. Is there a way to restrict the size of a request from the dashboard and display a message to the user they have exceeded the size request parameters? Any help, or direction to online help manuals for this type of coding is appreciated!! Thanks!This message has been edited. Last edited by: Kerry, WF7.7 WIN 08 SERVER SP2 EXL2K, HTML, PDF | ||
|
| Virtuoso |
In my opinion output reports of that size should always be avoided, since people tend to download all the data and use excel to create reports. I think you should create reports that do give information and not raw data, so it should never be that huge Drill down at lower level should give some details. Restricting end user to only partial information would not give the information one need.
| |||||||
|
| Platinum Member |
Report size can be limited by General or user specific WHERE statements, record read limit, or record output limits. You could also invoke rules through the use of Resource Governor. Your disk space problem could also be caused by temporary files left behind by badly terminated reports or log file settings that don't limit the size or number of log files created. If you bounce the WebFOCUS Reporting Server you will regain the space lost to these temporary files. WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF | |||
|
| Expert |
You might like SET WEBVIEWER = ON so that the report is brought back to the browser 1 page at a time. Yes to your question about limits; if in your original fex, you HOLD the initial extract file, you can test for the size of that file before you decide if it is reasonable to present the results to the user. TABLE FILE CAR PRINT MODEL ON TABLE HOLD END -RUN -SET &howmany = &LINES ; -IF &howmany LE 100000 GOTO rep.gen ; -TYPE Dude, you've just asked for &howmany records; way too many; Refine your parameter selection, and try again -EXIT -rep.gen TABLE FILE HOLD ... do some nice styling and present results to user END
| |||||
|
| Expert |
There would have to be a caveat on this, as it should depend on the type of report being produced. Consider PDF reports, these are formatted and can contain much information, then add images, logos, etc. This will make an even larger report. They can get quite large. You need to be very carefull about any blanket restrictions on output. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| 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 |