Focal Point
[SOLVED] Excel output filenames

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

March 25, 2019, 05:14 PM
jrbrown00
[SOLVED] Excel output filenames
Why does webfocus (apparently) generate two completly different filenames, depending on how the progam is invoked?

When I initially open App Studio (8201), navigate to a report in the Environments Detail, right-click and select run, excel output filename is in the format reportname_ccyymmdd_hhmmss. If I open the file and then select run, using either f5 of the little blue arrow, the filename is a cryptic ~abcdef1.xls. I see nothing in the code to handle this and I am new enough to WebFOCUS that I cannot find the control for this

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8201M
Windows
Excel
March 26, 2019, 07:29 AM
MartinY
Try with this. The key is : AS YourFileName

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
ON TABLE PCHOLD AS YourFileName FORMAT XLSX
END



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
March 26, 2019, 08:21 AM
jrbrown00
Perfect! Thank you


WebFocus 8201M
Windows
Excel