Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Active HTML export to excel breaks in the middle

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Active HTML export to excel breaks in the middle
 Login/Join
 
Saravanan J
Silver Member
posted
Hi All,

I created an Active HTML and in order to allow the user to use the "Export to Excel" feature of the AHTML, the IE ActiveX property has been enabled.. There is no issue in exporting to excel as long as the user maintaince his patience by not clicking on the excel sheet before the entire report is rendered.... Say if there are some 100K records being exported (which takes a considerable amount of time), the excel sheet opens up first and then starts buffering the remaining data. During this time, if the user clicks anywhere on the the excel sheet, the buffering stops abruptly leaving only partial data being exported.... Is there a work around for this issue??? I will be happy if the excel sheet opens up only after all the records are buffered. Which will eliminate this scenario.. Please help.

This message has been edited. Last edited by: Kerry,


Release : 7.7.02
OS : Linux
App Server : Tomcat
all output
 
Posts: 36 | Registered: February 03, 2011Report This Post
Sayed
Guru
posted Hide Post
I'd give the user an option to select report type (AHTML, EXCEL, PDF, etc..) before running the report.
AHTML wasn't intended for that much data from what I know. It will take up a lot of resource to load that.

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Saravanan J
Silver Member
posted Hide Post
Thanks Sayed, I will try to push that as a alternative. However most of the users play around with the data in the AHTML and try to export only the filtered records to excel..

I tried setting ON TABLE CACHELINES 100 and added the site to my IE Trusted sites. Now the Excel opens up after the entire data is buffered. Since i was making many changes i was not sure which step has fixed my problem. Anyways my issue is fixed for now :-)


Release : 7.7.02
OS : Linux
App Server : Tomcat
all output
 
Posts: 36 | Registered: February 03, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Active HTML export to excel breaks in the middle

Copyright © 1996-2020 Information Builders