Focal Point
[SOLVED] Subtotal Line

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4127075186

April 01, 2016, 01:22 PM
Thias Mercer
[SOLVED] Subtotal Line
Can the subtotal line on a report be moved from the bottom of the group to the top?

This message has been edited. Last edited by: Tamra,


WebFOCUS 8.0
April 01, 2016, 03:10 PM
Tom Flynn
Hi Thias,
The GUI doesn't have this setting, so, unless you want to keep using the GUI, no joy!!
It was requested in 2012, guess not a priority...

If you want to Edit via the Text Editor, under

ENGINE INT CACHE SET ON

add:
SET SUBTOTAL = ABOVE

Won't be able to open in GUI again, unless you Edit with the Text Editor, remove it, make your changes, then, put it back in at the very end...

Good Luck!
Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
April 05, 2016, 08:32 AM
BabakNYC
One way to keep the GUI and have SET commands is to create a reporting object and place the SET in the Preprocessing section.

That'll let you open the report with the GUI and have SET SUBTOTAL = ABOVE in the code.


WebFOCUS 8206, Unix, Windows