Focal Point
[SOLVED] Export Active report to Excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4807022196

April 05, 2019, 08:44 AM
jgelona
[SOLVED] Export Active report to Excel
I have an active report. When I click on the filter arrows in the column headings, in the drop down menu, there is an Export option, select that and there is an XML (Excel) option, select that then there is an All records or Filtered only. Selecting either of those open and new browser window with the XML data. What good is that? How does a user get that into Excel? The selections imply that the data will be exported as XML and open in Excel. That is not what happens.

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


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
April 05, 2019, 08:54 AM
BabakNYC
What browser/version are you using?

Make sure you have the following code:
 
ON TABLE SET WEBVIEWER ON
ON TABLE SET CACHELINES ON
 



WebFOCUS 8206, Unix, Windows
April 05, 2019, 09:24 AM
jgelona
Don't laugh, IE 11.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
April 05, 2019, 09:33 AM
jgelona
That fixed that problem so thanks for that. This report has a BYTOC option for worker name and now only the first worker shows and the worker name does not get exported. I believe I'm going to have to make some other changes. Thanks.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.