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     Styling reports using CSS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Styling reports using CSS
 Login/Join
 
Member
posted
Hello,

Does anyone know if its possible to get a css class in the table declaration. I'm using the WebFocus webservices to execute my reports so need to return everything as a HTMTABLE so I can then embed it into my .aspx page. The .aspx page is already using a css file for its styling so I would like to be able to place the styles for the returned WebFocus report in here too.

At the moment I'm doing the following:

-* File testCss.fex
TABLE FILE TENDERINFO
PRINT
QUOTEHEADERID AS 'Quote Header Id'
TENDERID AS 'Tender ID'
COMPANYNAME AS 'Company Name'
ON TABLE SET ACCESSIBLE '508'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTMTABLE

ON TABLE SET STYLE *
TYPE=REPORT, CSSURL=noFile.css, $
TYPE=DATA, CLASS=tableData, $
ENDSTYLE
END

This is generating the following:














Quote Header Id

Tender ID

Company Name

1234567890

12345678

Company 1 Ltd


I want to be able to have no style information contained in the generated HTML at all. Ideally, I want it to look like this:













Quote Header IdTender IDCompany Name
123456789012345678Company 1 Ltd


I can then reference the table in my css file as follows:

.table1 {border: 1px solid #000;}
.table1 th {font-weight: bold;}
.table1 td {padding: 0.5em;}

Does anyone know if this is possible??

Thanks

Micheal
 
Posts: 12 | Registered: August 17, 2007Report This Post
Member
posted Hide Post
Looks like I made a hash of posting. Hopefully this should show my code:

Generated code:

<TABLE BORDER CELLPADDING=1>
<TR>
<TH scope='col' ALIGN=RIGHT VALIGN=BOTTOM>
Quote Header Id</TH>
<TH scope='col' ALIGN=RIGHT VALIGN=BOTTOM>
Tender ID</TH>
<TH scope='col' VALIGN=BOTTOM>
Company Name</TH>
</TR>
<TR>
<TD CLASS='tableData' ALIGN=RIGHT>
1234567890</TD>
<TD CLASS='tableData' ALIGN=RIGHT>
12345678</TD>
<TD CLASS='tableData'>
Company 1 Ltd</TD>
</TR>
<TR>
</TABLE>


How I want it to be:

  
<TABLE class="table1">
<TR>
<TH scope='col'>Quote Header Id</TH>
<TH scope='col'>Tender ID</TH>
<TH scope='col'>Company Name</TH>
</TR>
<TR>
<TD>1234567890</TD>
<TD>12345678</TD>
<TD>Company 1 Ltd</TD>
</TR>
<TR>
</TABLE>


I can then reference the table in my css file as follows:

  
.table1 {border: 1px solid #000;}
.table1 th {font-weight: bold;}
.table1 td {padding: 0.5em;}
 
Posts: 12 | Registered: August 17, 2007Report This Post
Expert
posted Hide Post
I don't think there's a way to completely eliminate styling when creating an HTMTABLE formatted output file.

I have done this to create an output file containing HTML TABLE rows:

TABLE FILE CAR
SUM
COMPUTE TRB/A4 = '<TR>';
COMPUTE TDB/A20 = '<TD CLASS=TABLEDATA>';
COUNTRY
COMPUTE TDE/A5 = '</TD>';
COMPUTE TDB/A20 = '<TD CLASS=TABLEDATA>';
SALES
COMPUTE TDE/A5 = '</TD>';
COMPUTE TRE/A5 = '</TR>';
BY COUNTRY NOPRINT
ON TABLE HOLD AS H001 FORMAT ALPHA
END
-RUN
-HTMLFORM BEGIN
<TABLE>
!IBI.FIL.H001;
</TABLE>
-HTMLFORM END


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
Member
posted Hide Post
yep what you need to do is insert html code as part of the report. Just do it in the define.

Another thing I've done to add line by line highlighting is to write a post processing script that takes in the html page produced by webfocus and add whatever html I want prior to it being displayed.
 
Posts: 9 | Registered: August 20, 2007Report 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     Styling reports using CSS

Copyright © 1996-2020 Information Builders