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]WF 8.0.08 and IE11 and FML with indentation - does not work together

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]WF 8.0.08 and IE11 and FML with indentation - does not work together
 Login/Join
 
Francis Mariani
Expert
posted
I have several FML reports where the indentation does not work in IE11. I use IE11 Developer Tools and have to set the Document Emulation Mode to IE5 before the indentation starts working.

What's going on?

This is in relation to my other problem - GUI parameter screen built in Dev Studio v7.7.03 does not work in WF 8.0.08/IE11

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


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
If you read "IE5" to mean "Internet Explorer 5", your eyes are not deceiving you.

This doctype (found at the top of GUI-built HTML files) sets the mode to IE5:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">


The FML reports run in a frame in HTML Composer created HTML pages. I need to take the WF 8.0.08 HTML files and change the doctype to the one above.

Meanwhile, this does not solve my other problem, "GUI parameter screen built in Dev Studio v7.7.03 does not work in WF 8.0.08/IE11"...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
Haven't needed to use FML in 8 yet.

Is there any difference in the output from running in a frame to running in its own window ?


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
eric.woerle
Master
posted Hide Post
I just thought IE10 was suspect and IE11 was synonymous with "Good Luck"....

I don't think I have any luck running most things in IE11 with 8.0.08... then again my company seems to think that everyone still uses IE8. They will push upgrades for FF and chrome to something within the last year.... But IE... thats stuck back in IE8 here.... Luckily I got Admin rights on my machine... So I develop to IE 9. Seems the most stable for WF out of the IE versions.... I don't even want to think about building for Edge.

SMH


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
Francis Mariani
Expert
posted Hide Post
I used WF 8.0.08 Dev Studio HTML Composer to create a new HTML page with a meta-tag to force the page to IE8 and this seems to work for reports within the iframe. If the report is run outside the iframe, they will only work if Compatibility Mode is on, or if you use Developer Tools and set the compatibility mode to IE5 (!)


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
Wow Eeker


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
eric.woerle
Master
posted Hide Post
QA Testing at its finest....


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
Francis Mariani
Expert
posted Hide Post
Update: After making everything work in our Dev environment, I deployed the files to the QA environment. Indenting does not work in this environment. I determined it was because the QA, UAT and Prod environments are using IE11 in Enterprise Mode with emulation set to IE9. BUT this emulation overrides the IE8 emulation I set in the files!!!!

The only thing I can think of is to use the old DOCTYPE that DevStudio v7.7.03 HTML Composer used and remove the X-UA-Compatible header. This seems to override the IE11 Enterprise Mode IE9 emulation and sets the page to IE5. This then allows indentation to work.

BUT these pages do not work in DEV where we do not use IE11 in Enterprise Mode.

Microsoft and WebFOCUS working hand-in-hand. NOT.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
It shouldn't be this difficult


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
Francis Mariani
Expert
posted Hide Post
It's this difficult because Information Builders hitched their wagon to Internet Explorer and forgot to ditch it when everyone else did. They should have been generating standards-compliant HTML years ago. I think the problem is that the indentation is achieved with span tags that have a specific width. But these spans are generated without any content, so modern web browsers collapse the span to zero or 1 pixel.

I'd be curious to see FML hierarchic HTML generated by v8.1.04 or v8.1.05.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
Got some sample code ?


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
Francis Mariani
Expert
posted Hide Post
Simple test. Run the fex below. This is taken from the manual: Creating Reports With WebFOCUS Language > Creating Financial Reports With Financial Modeling Language (FML) > Reporting Dynamically From a Hierarchy > Displaying an FML Hierarchy

SET BLANKINDENT=ON
TABLE FILE CENTGL
PRINT GL_ACCOUNT_PARENT
FOR GL_ACCOUNT
3000 WITH CHILDREN 2
END


The result:

<!--Olap Javascript-->
<html>
<head>
<meta name="HandheldFriendly" content="True">
<meta name="PalmComputingPlatform" content="True">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<title>WebFOCUS Report</title>
</head>
<body>
<table border cellpadding=1>
<tr>
<td colspan=2>
<table cellpadding=0 width="100%"><tr>
<td>
PAGE     1</td></tr></table></td>
</tr>
<tr>
<td valign=BOTTOM>
 </td>
<td valign=BOTTOM>
Parent</td>
</tr>
<tr>
<td>
3000</td>
<td>
1000</td>
</tr>
<tr>
<td>
<span style='width:18pt'></span>3100</td>
<td>
3000</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3110</td>
<td>
3100</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3120</td>
<td>
3100</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3130</td>
<td>
3100</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3140</td>
<td>
3100</td>
</tr>
<tr>
<td>
<span style='width:18pt'></span>3200</td>
<td>
3000</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3300</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3400</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3500</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3600</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3700</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3800</td>
<td>
3200</td>
</tr>
<tr>
<td>
<span style='width:36pt'></span>3900</td>
<td>
3200</td>
</tr>
</table>
</body>
</html>
<!--
0 NUMBER OF RECORDS IN TABLE=       14  LINES=     14
0 HOLDING HTML FILE ON PC DISK ...

-->


In WF 8.0.08 and IE11, the indentation does not work. Using Developer Tools, I have to set the emulation mode to IE5 before it works. I betcha that in WF 8.1* there's something in the span, a   perhaps...

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
And it definitely does not work in Chrome Browser, v.whatever...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
Looks like I don't have CENTGL, I'll look for another


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
Wep5622
Virtuoso
posted Hide Post
What if you add a stylesheet that sets spans to behave like this?:
span {
  display: inline-block !important;
/* or perhaps:
  position: relative;
*/
}


(the default for spans is 'inline', which ignores any width)


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
Tony A
Expert
posted Hide Post
quote:
Looks like I don't have CENTGL, I'll look for another

Waz, it is in IBINCCEN which is not normally contained in the app path.

I only see indentation using the internal viewer with App Studio.

I'll check Win10 and Edge later.


T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Tony A
Expert
posted Hide Post
No indent on Edge Frowner

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Waz
Expert
posted Hide Post
quote:
Waz, it is in IBINCCEN which is not normally contained in the app path.


Yes, unfortunately inst not installed at all.

Will see if I can get it, guessing its an option on install.


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
Waz
Expert
posted Hide Post
Found an old copy, and its producing the same.

Using SPAN to create the indent


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
Tony A
Expert
posted Hide Post
As this is only in HTML format (PDF is still actioned) then Wep's suggestion to add the following CSS as required should effect a solution.

span {display: inline-block;}

I added it to baseapp/block_spans.css and then included it in the focexec as
SET CSSURL = '/approot/baseapp/block_spans.css'


Sorted it out in IE11 ok, also Chrome - not tried FireFox but would assume (dangerous) that would be OK as well.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Waz
Expert
posted Hide Post
Will this be used with tablet or mobile devices ?

You should also check safari, etc


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
Francis Mariani
Expert
posted Hide Post
These reports are not viewed on mobile devices. Thanks for the tips and trying it out. I'll try the CSS.

Cheers,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
I can confirm that 
span {display: inline-block;}
works in IE11 in Enterprise Compatibility Mode, so, thanks very much gents.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
CoolGuy
Virtuoso
posted Hide Post
Been trying to replicate some of IBI's tablesaw.js functionality and if you look at the page source, you can see quality tool-generated code in action...*rolls eyes*

Found:
<head>
<meta name="HandheldFriendly" content="True">
<meta name="PalmComputingPlatform" content="True">


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Waz
Expert
posted Hide Post
quote:
These reports are not viewed on mobile device


Consider yourself lucky.....


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
Tamra
Guru
posted Hide Post
Hi Francis and others,

Just FYI....

Web Browser Support for WebFOCUS Releases 8.0.10 - 8.0.01

There is nothing noted specifically on FML but other features are noted as supported with IE 10 for WebFOCUS 8008.


Here are a few links found on the IBI TechSupport site that may / may not help.

Indenting FML RECAP Rows in HTML not working
Can you indent Verb Objects in FML (Yes, an older version of WebFOCUS)


Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit

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


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report 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]WF 8.0.08 and IE11 and FML with indentation - does not work together

Copyright © 1996-2020 Information Builders