 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Active Reporting times out
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Active Reporting times out Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Active Reporting times out | Login/Join |
| Member |
I have a report that I would like to add active reporting to which I did by adding a A infront of HTML on the ON TABLE statement. ON TABLE PCHOLD FORMAT AHTML ON TABLE SET STYLE * However when I run the report it times out and I get a blank screen. It will only run when I set a RECORDLIMIT EQ 50 plus or minus a few records. Does anyone know how to get the report to run with a larger volume of records? I should be able to retrieve more than 50 and have active reporting enabled. Thanks in advance.This message has been edited. Last edited by: Kerry, WF 7.6.4 MS Office 2003 | ||
|
| Expert |
So, The ONLY thing you changed is "HTML" to "AHTML", right? How many records, lines in your report? Can you duplicate the issue with the CAR or EMPLOYEE file, or any other IBI Supplied / common file?
| |||||
|
| Virtuoso |
A couple things are in play here. First, AHTML output is not available on a WF server unless you have purchased a license key for the Active Reports option. You can develop those reports in DevStudio, but you can't deploy them to the server. They will not run. Also, because Active Reports has to send ALL of the data back to the browser as a dataset for processing using Javascript, the quantity of data becomes an issue. I know that IBI is working to increase the limits, but there was about a 5000 record limit. Again, that will depend on data quantity - if you are returning 50 records with 500 columns each, you've still got a problem. Doug's suggestion to try AHTML with the CAR file is a good starting point. If it still does not work, you've got a licensing issue or some other network problem. If it does work, then it's purely an issue with data quantity. I don't believe AHTML has ever worked very well for very large data sets. 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 | |||
|
| Expert |
Thanks Darin, I wasn't sure about that... | |||
|
| Member |
Thanks for the respones. We do currently have a licence key for the Active Reports option. I believe the issue is after talking with some associates here is that I need to be running the data extract on the server side and not the client side (my pc) using the FOC CACHE option. However I can't find any info under the help option in Devl studio. Any ideas or thoughts about how to use FOC CACHE? I do have another report that retrieves over 800 records so I'm not sure why that one works and this one doesn't. WF 7.6.4 MS Office 2003 | |||
|
| Expert |
FOCCACHE was a 7.6.5 feature. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Member |
GinnyJakes - So you're saying that since I'm running 7.6.4 the FOC CACHE option is not available? Or it's not available at all anymore? Thanks. WF 7.6.4 MS Office 2003 | |||
|
| Expert |
FOCCACHE is not available in your release. I'm sorry. It is a great feature. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Member |
I fixed the issue by reducing the number of fields on the report. Does anyone know if there is a way to wrap a lengthy field on an Active report? For example if a field is very long in the data source you have to scroll left to right. When you remove active reporting it displays much better in multiple lines for that field and you don't need to scroll however I would like to have the active reporting feature enabled. I tried all the options in the GUI with no success. Thanks in advance! WF 7.6.4 MS Office 2003 | |||
|
| Platinum Member |
I think IBI has developed the feature to WRAP the AHTML columns in 7.9 version. Regards, Cyril Joy. WF Production 8008 on Linux. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Active Reporting times out
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Active Reporting times outCopyright © 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 |