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.
We have reports where several columns have values which are icons that appear when specific criteria are met, and these icon serve as links for drill-downs.
The icons are created as define fields with HTML syntax referencing the .gif files. The format is A150.
I need to create a legend in the footing for these icons. The challenge is keeping the text on the same line as the icons. Even when I reduced the size as much as possible to A107, the text still wraps. This is a wide report, but regardless, I still need to keep the icons and text on the same line.
How is this accomplished?
Thank you,
John
WF 7.7.03, Windows 7, HTML, Excel, PDF
Posts: 225 | Location: San Francisco Bay Area, California | Registered: October 26, 2006
DEFINE FILE CAR
TIMG1/A100 =
'<IMG SRC="https://forums.informationbuilders.com/groupee_common/styles/images/set2/go.gif">';
TIMG2/A100 =
'<IMG SRC="https://forums.informationbuilders.com/groupee_common/styles/images/set2/find.gif">';
END
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
SEATS
COMPUTE SEATS_IND/A100 = IF SEATS GT 3 THEN TIMG1 ELSE TIMG2; AS ''
HEADING
"WEBFOCUS REPORT"
FOOTING
"<TIMG1 This is a B <TIMG2 This is a C"
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
To achieve what you want I think you need to stop thinking of the output in terms of WF length and concentrate on how the HTML is built from WF.
The HTML generated for a footing generally is within a table of it's own and usually is set to 100% of the report width. Each component will be placed within a TD. Now, if your report is quite narrow then you will always get wrap if your footing is lengthy - it's what HTML does. So you can change the width of your report or change the contents of the footing so that you control the contents.
In Francis' example you will notice that the HTML for the footing will have been created with 4 TDs owing to the combined use of fields and text. If you were to change the defines and computes for the images to suit how you use them, then you could gain the result that you are after -
APP PREPENDPATH IBISAMP
DEFINE FILE CAR
UP_ARROW/A200 =
'<IMG SRC=\ibi_html\javaassist\icons\ArrowUpBtn16.gif>&|nbsp;Profit is greater than 20%';
DW_ARROW/A200 =
'<IMG SRC=\ibi_html\javaassist\icons\ArrowDownBtn16.gif>&|nbsp;Profit is less than 20%';
END
TABLE FILE CAR
SUM RCOST
DCOST
COMPUTE PCNT/D6.2 = (RCOST - DCOST) / DCOST * 100;
COMPUTE ICON/A150 = IF PCNT LT 20 THEN '<IMG SRC=\ibi_html\javaassist\icons\ArrowDownBtn16.gif>'
ELSE '<IMG SRC=\ibi_html\javaassist\icons\ArrowUpBtn16.gif>';
BY COUNTRY
BY CAR
BY MODEL
FOOTING
"<UP_ARROW"
"<DW_ARROW"
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
TYPE=DATA, COLUMN=ICON, BACKCOLOR=RED, WHEN=PCNT LT 20, $
ENDSTYLE
END
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, 2004