Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Active HTML export to excel breaks in the middle
 Login/Join
 
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, 2011Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.