Hi All,

I am facing a weird issue with output filename for EXL2K format report. By default, EXL2K report generates with a temporary filename (like: abcdef.xls). I have to change this temporary filename with another string (like: car_sale.xls).

To achieve this, I have used below line in my code.

 ON TABLE PCHOLD AS 'car_sale' FORMAT EXL2K  

The above code is working fine, when I execute report via App Studio tool (WebFocus ver 8.105M), but it does not work, when I execute report from a HTML Ad Hoc web page.

Please suggests, what changes should i made in my code.

Thanks in advance.


Regards,
Sandy

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

I don't have 8.1 anymore but in 8.201 this generates CAR_SALE_20171027_071327.xls.

Have you tried format EXL07?

Same with 8.1.05 (Gen 939):
car_sales_20171027_020007.xls

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD AS 'car_sales' FORMAT EXL2K
END

Regards. Mikel.

quote:

code is working fine, when I execute report via App Studio tool (WebFocus ver 8.105M), but it does not work, when I execute report from a HTML Ad Hoc web page.

Could you describe what isn't working?

Sandy,

This may have to do with your redirection settings in your configuration console. Can let us know how excel files are configured?