Hi,

Iam creating report with EXL2K format. If i give a name(REP1) for report output, it's not working for EXL2K format.(It's working for EXL07 format)
I have changed the Save Report option to "Yes" for .xls Extension in WebFOCUS Administration Console>Configuration>Redirection Settings.

Below is my Code.
Help me on this issue.

 
TABLE FILE CAR
SUM COUNTRY
 ACROSS MODEL
BY CAR
ON TABLE SET CENT-ZERO ON
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD AS REP1 FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Car Example', $ 
TYPE=ACROSSVALUE,CLASS=rotate,$
ENDSTYLE
END

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

I just tried your code in 8105 and got an Excel output called REP1.xls. What is it supposed to be doing that's not working?

What version of WF8 do you have ?

Waz

Iam working in WF 8009

We are using 8.0.08. I have Excel 2003 and Excel 2010 on my PC. Neither returns a filename of REP1. When we run Excel output, it open in Excel not the browser version of Excel (we are also an IE shop).

I know with Excel 2003 and earlier, what is generated in WebFOCUS is not a true .xls file but a .mht or .xht file format, so that may be part of the issue. The filename I get is WFServlet.ibfs. If I try to save the file, Excel thinks it is a .html file.

I have Excel 2007 on my PC

If i use

 SET WEBARCHIVE=OFF 

in code, the excel output comes with given name, but it's not working in Compound reports..

Finally i got some reference from below link

http://documentation.informati...f761sec/wf761sec.pdf

In WebFOCUS Administration Console>Configuration>Redirection Settings, changed the Save Report option to "Yes" for ".xht", ".xmh" & ".xls" WebFOCUS extensions.

So, if u run the report, it will show in ".xmh" format(Report_Name.xmh).
if we Open\Save the report directly from browser, it will ask "How do we want to open this type of file?". we need to select Excel as a default open type from options.

Hope this is the solution for this issue..

can anyone let me know is this correct or is there another way to achieve this....