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     [CASE-OPENED] -UNDERLINE in EXL2K Output - different than HTML/PDF?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] -UNDERLINE in EXL2K Output - different than HTML/PDF?
 Login/Join
 
globalwm
Gold member
posted
I have the following style that removes the underlines from appearing in HTML and PDF for Drill-Down enabled columns that are non zero:


$
TYPE=DATA,
COLUMN=N6,
WHEN=N6 NE 0,
STYLE=-UNDERLINE,
COLOR=RGB(8 0 0),
TARGET='_blank',
...


However, when output changed to EXL2K, the underlines appear. Is this the expected outcome or do I need to use an additional statement for EXL2K output?

Thanks.

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


8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
 
Posts: 72 | Registered: November 12, 2012Report This Post
Mighty Max
Guru
posted Hide Post
Looks EXL2K format adds an underline to all hyperlinks. It overrides the WebFocus stylesheet. Maybe you can remove the drilldowns for the records that a value of zero. Do the users need to see the details of a zero value?

  
DEFINE FILE CAR
SEATS/I11 = IF COUNTRY EQ 'ENGLAND' THEN 0 ELSE SEATS;
END

TABLE FILE CAR
PRINT 
     COUNTRY
     CAR
     MODEL
     DEALER_COST
     RETAIL_COST
     SEATS
     COMPUTE FLAG/A1 = IF SEATS EQ 0 THEN 'N' ELSE 'Y'; NOPRINT

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
-*   TARGET='_blank',
-*   FOCEXEC=drill,
     WHEN=N7 EQ 'N',
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
     TARGET='_blank',
     FOCEXEC=drill,
     WHEN=N7 EQ 'Y',
$
ENDSTYLE
END


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
globalwm
Gold member
posted Hide Post
That is what I tried to do with:
 
WHEN=N6 NE 0,


which works fine (no DD on zero values) on HTML and PDF.
 
Posts: 72 | Registered: November 12, 2012Report This Post
Doug
Expert
posted Hide Post
Consider using the WHEN in your stylesheet based on that value. WHEN it 0 then there's no link otherwise there is. This requires two lines in the stylesheet to perform as desired.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Mighty Max
Guru
posted Hide Post
Open a case with IBI this appears to be a bug. Tell them that EXL2K overwrites the WebFocus stylesheet. You don't want underlines in any of your drilldowns. You can give them this basic sample fex using the CAR file.

  
DEFINE FILE CAR
SEATS/I11 = IF COUNTRY EQ 'ENGLAND' THEN 0 ELSE SEATS;
END

TABLE FILE CAR
PRINT 
     COUNTRY
     CAR
     MODEL
     DEALER_COST
     RETAIL_COST
     SEATS

ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
     TARGET='_blank',
     FOCEXEC=drill,
     WHEN=N6 NE 0,
$
ENDSTYLE
END



Ok I think I got it working but you will have to hold as HTMTABLE. Then SET the HTMLFORMTYPE to XLS and then change the styling hyperlinks using CSS. You might not like this workaround.

  
DEFINE FILE CAR
SEATS/I11 = IF COUNTRY EQ 'ENGLAND' THEN 0 ELSE SEATS;
END

TABLE FILE CAR
PRINT 
     COUNTRY
     CAR
     MODEL
     DEALER_COST
     RETAIL_COST
     SEATS

ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS H1 FORMAT HTMTABLE
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
$
TYPE=DATA,
     COLUMN=N6,
     COLOR=RGB(8 0 0),
     STYLE=-UNDERLINE,
     TARGET='_blank',
     FOCEXEC=drill,
     WHEN=N6 NE 0,
$
ENDSTYLE
END

SET HTMLFORMTYPE=XLS
-HTMLFORM BEGIN
<!DOCTYPE html>
<html>
<head>
<style type="text/css"> 
A { font-family:TIMES NEW ROMAN !important; 
    font-size:10pt !important; 
	font-style:normal !important; 
	color:black !important; 
	text-decoration: none !important;  
  }
</STYLE>
</head>
<body> 
!IBI.FIL.H1;
</body>
</html>
-HTMLFORM END


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
Doug
Expert
posted Hide Post
It works fine for me without needing the "ON TABLE HOLD AS H1 FORMAT HTMTABLE", just a plain old "ON TABLE PCHOLD FORMAT EXL2K" and the "WHEN=N6 NE 0".
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Mighty Max
Guru
posted Hide Post
Can you post a screenshot?
Here is a screenshot of what I get using 7.6.10.
He does not want the underlines on the drilldown hyperlinks.



WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
Doug
Expert
posted Hide Post
It was my understanding that he did not want the underlines on the zero values and that the underlines on the non-zero values was OK.

Is that correct globalwm?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
globalwm
Gold member
posted Hide Post
Hi Doug,

No - no underlines at all. That's how HTML and PDF is displaying. I think it looks messy.

These reports are run from a HTML Dashboard where the User selects a report and its parameters - and selects an output type. This is passed as a variable using &WFFMT to the Parent report and also gets to the Drill Down (hyperlink) where the Child report accepts.

Like I said above, this (using the -UNDERLINE) works fine in HTML and PDF - just not Excel. Was just wondering if this is an expected behavior (or not) and what else could be done to produce the same results like on the other formats.


8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
 
Posts: 72 | Registered: November 12, 2012Report This Post
globalwm
Gold member
posted Hide Post
Mighty Max suggests a bug and I can certainly open a trouble ticket with Support. Just wanted to see if others are having the same issue here.

Thanks!


8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
 
Posts: 72 | Registered: November 12, 2012Report This Post
globalwm
Gold member
posted Hide Post
Ticket #90042543 opened with IBI Support.


8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
 
Posts: 72 | Registered: November 12, 2012Report 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     [CASE-OPENED] -UNDERLINE in EXL2K Output - different than HTML/PDF?

Copyright © 1996-2020 Information Builders