I am a report where I use the total functionality and this lines come at the end of each section. Is that possible to have the subtotal line at the top of each section? If not, does someone knows how can I accomplish this?
Let's say I have a report by country/city and then a subtotal by country. This sub total line in webfocus will come after the last city for this country. The user would like the subtotal line at the top?This message has been edited. Last edited by: Tamra,
WebFOCUS 8.2.0.7, Application Studio, Webfocus Info-Assist iWay Service Manager, iWay Data Migrator Windows, All Outputs IBM DB2/400, MS SQL-Server 2014
March 28, 2016, 05:36 PM
Waz
In the code you can use SET SUBTOTALS = ABOVE
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 29, 2016, 11:06 AM
vnf
it works for the subtotal lines but the grandtotal line is now at the top.
Can we leave the grandtotal to the bottom?
WebFOCUS 8.2.0.7, Application Studio, Webfocus Info-Assist iWay Service Manager, iWay Data Migrator Windows, All Outputs IBM DB2/400, MS SQL-Server 2014
March 29, 2016, 05:02 PM
Waz
I don't know
I would suggest researching the command.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 30, 2016, 03:42 PM
Danny-SRL
I would suggest using ON TABLE NOTOTAL ON TABLE SUBFOOT " code here for the totals alignment "
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF