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 thisThis 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