Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL2K Output file Name

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] EXL2K Output file Name
 Login/Join
 
Maran
Gold member
posted
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,


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
BabakNYC
Virtuoso
posted Hide Post
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?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Waz
Expert
posted Hide Post
What version of WF8 do you have ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Maran
Gold member
posted Hide Post
Waz

Iam working in WF 8009


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
jgelona
Master
posted Hide Post
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.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Maran
Gold member
posted Hide Post
I have Excel 2007 on my PC


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
Maran
Gold member
posted Hide Post
If i use 
 SET WEBARCHIVE=OFF
in code, the excel output comes with given name, but it's not working in Compound reports..
Sweating


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
Maran
Gold member
posted Hide Post
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.. Smiler

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


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
 
Posts: 86 | Location: India | Registered: November 03, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL2K Output file Name

Copyright © 1996-2020 Information Builders