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     using htmtable without the table...

Read-Only Read-Only Topic
Go
Search
Notify
Tools
using htmtable without the table...
 Login/Join
 
Platinum Member
posted
Is there a way to strip just the value out of a report saved as htmtable? I normally get this:

 !--Olap Javascript-->
<TABLE BORDER CELLPADDING=1>
<TR>
<TD ALIGN=RIGHT>
$62,420,380.98</TD>
</TR>
</TABLE> 


All I want is $62,420,380.98

Thanks.


-Brian

Webfocus v7.6.1 on Windows XP
 
Posts: 108 | Registered: June 19, 2006Report This Post
Expert
posted Hide Post
Brian,

You just want the value shown on the screen? Use FORMAT HTML ...

Otherwise, a little more explanation please.

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
Gold member
posted Hide Post
quote:
$62,420,380.98

Use ALPHA Format




Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF
 
Posts: 52 | Location: NJ,USA | Registered: May 26, 2004Report This Post
Platinum Member
posted Hide Post
Okay, here's more explanation. The report is below (just the important part).

What I want is for the 2 reports to sit side by side in the table cell, however since the output of "htmtable" puts them inside a table it puts one table on top of the other. Now, my goal would be to get just the value of the report in the output without the table around it. This table is much larger than I am showing here, just fyi.

  
TABLE FILE RORSTAT
SUM RORSTAT_GRS_NEED/D12CM AS ''
BY RORSTAT_AIDY_CODE NOPRINT
WHERE RORSTAT_AIDY_CODE EQ '&AID_YEAR2'
WHERE RORSTAT_BGRP_CODE LIKE '&LEVL'
WHERE RORSTAT_GRS_NEED GT RORSTAT_UNMET_NEED
WHERE RORSTAT_GRS_NEED GT '0'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS RPRT2_1 FORMAT HTMTABLE
END

TABLE FILE RORSTAT
SUM RORSTAT_PIDM AS ''
BY RORSTAT_AIDY_CODE NOPRINT
WHERE RORSTAT_AIDY_CODE EQ '&AID_YEAR2'
WHERE RORSTAT_BGRP_CODE LIKE '&LEVL'
WHERE RORSTAT_GRS_NEED GT RORSTAT_UNMET_NEED
WHERE RORSTAT_GRS_NEED GT '0'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS CNT2_1 FORMAT HTMTABLE
END

-HTMLFORM BEGIN
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0">
<TR>
<TH ALIGN="RIGHT">DOCUMENTED NEED: </TH>
<TD>!IBI.FIL.RPRT2_1; !IBI.FIL.CNT2_1;</TD> <----------------This is the problem line with two reports side by side.
</TR>
</table>
-HTMLFORM END


-Brian

Webfocus v7.6.1 on Windows XP
 
Posts: 108 | Registered: June 19, 2006Report This Post
Expert
posted Hide Post
Brian,

If you want them side by side then just change your HTML to -

-HTMLFORM BEGIN
......
<TD>!IBI.FIL.RPRT2_1;</TD>
<TD>!IBI.FIL.CNT2_1;</TD>
......
-HTMLFORM 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, 2004Report This Post
Platinum Member
posted Hide Post
I wish it were that simple Tony, however I really need them in the same table cell.

So, I guess there's no way to just get the value without the formatting/table?


-Brian

Webfocus v7.6.1 on Windows XP
 
Posts: 108 | Registered: June 19, 2006Report This Post
Expert
posted Hide Post
quote:
I really need them in the same table cell
I don't really understand why you need this and they will never appear in the same cell either. It's just how the output is created. One data item - one cell.

If you just want the value then why not READ it into a variable and use it by saving the tabled output prior to your -READ?

If that's not an option then please expand on how you need your output with, perhaps, a hand cranked example?

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
Virtuoso
posted Hide Post
Brian,
Like Tony, it eludes me why you would want to have the data of both reports in one cell. That way you'll not get them side by side, but one on top of the other.
The only way to get them side by side is to put them into seperate table cells.
And if you don't want the htm tags around your data, then hold your data as format ALPHA. You'll just get the data then, but remember that HTML ignores white spave as well as returns. So in order to display the data correctly if you're not having html tags, put it between the pre and /pre tags, as in the example below:
TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS RPRT2_1 FORMAT ALPHA
END

TABLE FILE CAR
PRINT CAR
ON TABLE HOLD AS CNT2_1 FORMAT ALPHA
END

-HTMLFORM BEGIN
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0">
<TR>
<TH ALIGN="RIGHT">DOCUMENTED NEED: </TH>
<TD><PRE>!IBI.FIL.RPRT2_1; !IBI.FIL.CNT2_1;</PRE></TD>
</TR>
</table>
-HTMLFORM END

Hope this helps ...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Virtuoso
posted Hide Post
Does this help?:
SET HOLDLIST=PRINTONLY
SET PAGE=NOPAGE
TABLE FILE CAR
SUM RCOST/D12.2M AS ''
ON TABLE SAVE AS file1 FORMAT DOC
END

TABLE FILE CAR
SUM DCOST/D12.2M AS ''
ON TABLE SAVE AS file2 FORMAT DOC
END

-HTMLFORM BEGIN
<html>
<head>
</head>
<body>
<table>
 <tr>
  <th scope="row">DOCUMENTED NEED: </th>
   <td><span style="float:left;">!IBI.FIL.file1;</span>
       <span style="float:left;">&|nbsp;-&|nbsp;</span>
       <span style="float:right;"> !IBI.FIL.file2;</span></td>
 </tr>
</table>
</body>
</html>
-HTMLFORM END


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Platinum Member
posted Hide Post
Thanks guys for the help. The reason I need them in the same table cell is more about the look and feel I am going for, as the numbers are related to each other.

Alan, what you did worked like a charm.

Thank you.


-Brian

Webfocus v7.6.1 on Windows XP
 
Posts: 108 | Registered: June 19, 2006Report 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     using htmtable without the table...

Copyright © 1996-2020 Information Builders