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.
I have a requirement to display Total Row above the column values.SET SUBTOTALS = ABOVE parameter setting is not working for AHTML in WebFOCUS 7.7.03. Can anyone help me.This message has been edited. Last edited by: FP Mod Chuck,
WebFocus 7.7.3, Windows Operating System, HTML,PDF,EXCEL
Will you please confirm that your syntax resembles the following:
ON TABLE SET SUBTOTALS ABOVE (no '=' sign)
If this is in your code, would you please provide some additional information about how this isn't working? Are you seeing any error messages? If so, what are they? Please also provide the code that you're using.
For Active reports, the code for putting the Grand Total at the top is in the Stylesheet section. Using a modified version of Francis' CAR code:
TABLE FILE CAR
SUM SALES/D12.2
BY COUNTRY SUBTOTAL
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE NOTOTAL
ON TABLE SET STYLE *
TYPE=REPORT,CALC-LOCATION =TOP,COLUMN=N4, CALCULATION=SUM, $
ENDSTYLE
END
Jesni, this worked with version 7.1 so it should be good for your version 7.6.2.
SUBTOTAL (=) ABOVE is 7.7.x syntax, I believe, and will not work with your version. Not sure why it's not working for you Francis. We don't have 7.7.x yet.
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
Unfortunately, it's not working for me because several things don't work when outputting Active HTML reports.
I have never seen the CALC-LOCATION attribute, so thanks for pointing it out.
I've found the documentation for it and there's some interesting stuff there:
Active Technologies User's Guide, Version 7 Release 7.03 > Creating Active Technologies Components With WebFOCUS Syntax > How to Control the Calculations Options.
So, it puts a total at the top, but only a grand total, it does not put the subtotals at tthe top. Also, the grand total row is still at the bottom.
Also, this grand total looks different from all other WF report grand totals - "Total Sum 208,420" is shown in the cell. How does one not get the text "Total Sum"? And you can't make it bold.
TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY CAR
BY MODEL
ON CAR SUBTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
TYPE=REPORT, FONT='Arial', SIZE=9, $
TYPE=SUBTOTAL, STYLE=BOLD, $
TYPE=GRANDTOTAL, STYLE=BOLD, $
TYPE=REPORT, CALC-LOCATION=TOP, COLUMN=SALES, CALCULATION=SUM, $
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
For grand totals only. Use "ON TABLE NOTOTAL" to remove the standard grand total at bottom. Beyond the color and backcolor, I have not found a way to style or modify the "Total Sum..." text.
But here's somthing you may like...Use the CAR table with the calc-area visible and then filter on England. Check out the new item that is added to the "Total Sum" cell.
Then check out the new item next to the SUM icon in the status area block. Click on it a few times. Some very cool functionality!
And Danny-SRL, I agree on the roll-ups. BTW, the Calc-Area carries over to the Roll-Up window, too. Though, looking at it now, there appears to be a bug in how it calculates the sum total.
Anyway, some fun (and possibly useful) things to check out.
David
In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
-* File subabove.fex
SET SUBTOTALS=ABOVE
TABLE FILE CAR
SUM SALES
BY COUNTRY SUBTOTAL
BY CAR SUBTOTAL
BY MODEL
ON TABLE NOTOTAL
ON TABLE SUBFOOT
"Grand Total: <+0> <+0> <TOT.SALES"
ON TABLE SET STYLE *
TYPE=TABFOOTING, HEADALIGN=BODY,
$
ENDSTYLE
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006