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     [CLOSED]Chrome browser support

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Chrome browser support
 Login/Join
 
Guru
posted
Hi,

The business area asked me to add chrome support to a WF Report. Can anyone help me?

Thanks

 
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS DETAILS FORMAT HTMTABLE
END


TABLE FILE GGSALES
SUM UNITS
BY ST
ACROSS PRODUCT
ON TABLE HOLD AS SALES FORMAT HTMTABLE
END


-RUN

SET HTMLFORMTYPE=XLS


-HTMLFORM BEGIN
-*<html xmlns:o="urn:schemas-microsoft-com:office:office"
-*xmlns:x="urn:schemas-microsoft-com:office:excel"
-*xmlns="http://www.w3.org/TR/REC-html40">

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>


<style>
</style>
</head>
<body>
<table style="width:100%; height:100%" >
<tr>
<TD align="center">
!IBI.FIL.SALES;
</td>
<TR>
<TD>

<TD>
</TR>
</tr>
<tr>
<td>
!IBI.FIL.DETAILS;
</td>
</tr>
</table>
</body>
</html>
-HTMLFORM END

 

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
And the problem is?

quote:
Originally posted by Ricardo Augusto:
SET HTMLFORMTYPE=XLS


The above is almost certainly not correct when your output is in fact HTML.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Guru
posted Hide Post
No, it´s not. That was a remediation to reach report goal.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
I ran your code in Chrome Version 47.0.2526.111 using WF 8105 and it opened an Excel worksheet with the two reports in it. Is that not what you wanted to see?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Guru
posted Hide Post
OMG. BabakNYC, I am using the Chrome Version 47.0.2526.111 and APP Studio 8105 Gen 09132015 and It didn't open the excel. It creates a WFServlet.


Are you running it from MRE or URL?

I am trying to run it as http://http://localhost:8080/i...vlet?IBIF_ex=browser

Weird!


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
Yes you get a WFServlet and you'd have to pick an application to open it. If it's not automatically opening it in Excel, see if you can browse for it.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Guru
posted Hide Post
Do you mean it is configuration in Chrome? Maybe installing an extention?


I am able to open it on Excel after rename it to any_file.XLS


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
I believe it has to do with mime.wfs. Take a look at this case in tech support and see if it's the same problem.

https://techsupport.informatio...ttrack/92662013.html


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Guru
posted Hide Post
Thanks BabakNYC. I will check it asap.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Master
posted Hide Post
Ricardo,

This issue with Chrome first showed up a couple years ago. I believe it has to do with a change by chrome regardign how it handles the MHT extension (Which I believe is how the excel file gets sent if it is not saved on the server first). As Babak mentions, you can resolve this by adjusting the mime.wfs for the excel formats.

To adjust that file, you can do so in the Administration Console which is accessible from the client. Open up the Admin Console, expand the configuration section and go to redirection settings. You'll find what you need there.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Guru
posted Hide Post
Thanks Eric. I will ask to my WF admin.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
BabakNYC, I am not able to reach that case. I am getting HTTP 404 - File not found.


Also No documents matched the query "(((@all chrome AND support) AND (@all 92662013) AND (@ProductName APPSTUDIO OR DEVSTUDIO OR "PC/FOCUS" OR "WF/JDE" OR "WF/SAP" OR WORLDMART OR "WF/PPLSOFT" OR RESGOVERNOR OR RESANALYZER OR WEBFOCUS OR WF* OR EDA* OR IWAY* OR RPTSERV OR "WF/MAINTAIN" OR CACTUS OR "WF/PMF" OR "WF/RPTCASTER" OR "WF/VISUALDIS") AND NOT #filename *.pdf) OR ((@all chrome AND support) AND (@all 92662013) AND #filename *.pdf) AND NOT ((#vpath *\archive\*) OR (@Archive ARCHIVE)))".


Eric, I changed that redirection settings at my APP Studio but nothing changes.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
As mentioned already, goto administration console-->client settings-->redirection seetings-->.xls[change 'Save Report' from no to yes.]

You're good to go. Ask your WF admin to make the changes.

quote:
Eric, I changed that redirection settings at my APP Studio but nothing changes


You have to change in local reporting server running locally then, which should be http://localhost:8080/ibi_apps/


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Guru
posted Hide Post
Rifaz, As I said before, I went administration console-->client settings-->redirection seetings-->.xls[change 'Save Report' from no to yes.]

Reopened App Studio, then I opened browser.fex from chrome and I still get the result as WFServlet.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
<Emily McAllister>
posted
Hello,

Here is some information from our site regarding Chrome compatibility:

A change in the way Chrome works has caused it to stop respecting the XMH format as a Web Archive. A combination of two settings is required to resolve this problem:
Use SET WEBARCHIVE = OFF to change WebFOCUS processing from XMH to XHT format.
Change the Redirection Settings for the XHT format to Yes/Yes to redirect and
save the report to XLS format.

1. SET WEBARCHIVE = OFF
You can specify the command either directly within the .fex procedure itself
or you can specify the command within the edasprof.prf. Placing the command
within the edasprof.prf file allows it to be globally enabled for all
requests.
To set the command in the edasprof:
http://server:8121 (for a default installation)
Click Workspace and then Expand Configuration Files
Right click "Server Profile - edasprof.prf
Add SET WEBARCHIVE = OFF to a new line at the bottom of the file.

2. To set the Redirection Settings:
http://server:8080/ibi_apps/
Click WebFOCUS Administration Console
Expand Configuration
Click Redirection Settings
Change the settings for .xht format to Yes and Yes
Click Save at the bottom of the page
Click Clear Cache at the top of the page.

Please let me know if this solves your problem.


Thanks,
Emily McAllister
Focal Point Moderator
 
Report 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     [CLOSED]Chrome browser support

Copyright © 1996-2020 Information Builders