Focal Point
Using a compute in the grandtotal line?

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

September 06, 2007, 06:28 PM
Jason K.
Using a compute in the grandtotal line?
I'm not finding a way to put a compute into the grand total line.

Is there any way to do this? I need to compute based on the totals of two columns.


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
September 07, 2007, 07:03 AM
FrankDutch
Jason

this might be a solution

TABLE FILE CAR
SUM 
     SALES
     DEALER_COST/D10.2
     COMPUTE TEST/D12.2 = DEALER_COST / SALES; NOPRINT
BY DUMMY
BY COUNTRY
     
ON DUMMY RECOMPUTE AS '*TOTAL'
ON DUMMY SUBFOOT
"Dealercost per sales (dealercost/sales): <ST.TEST"
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=SUBFOOT,
     BY=1,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     POSITION='N4',
$
ENDSTYLE
END


This in PDF, in HTML you should use the grid to position that field.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 07, 2007, 09:50 AM
Jason K.
Thanks Frank!

I'm a little confused on what this means...
quote:
in HTML you should use the grid to position that field.


Where can I find information on positioning the field in a grid?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
September 07, 2007, 10:59 AM
FrankDutch
Jason

It's all in the manual, but a little course might help too.

If you put some text in the foot or header box, you can click right with the mouse.

(if you use the GUI)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 07, 2007, 11:18 AM
Prarie
GUI?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Developer Studio nicknamed the GUI


Leah
quote:
Originally posted by Prarie:
GUI?


Yes Prarie

Graphical User Interface...


Don't you use it?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

Nope Music


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
by grid, I was thinking it was something related to CSS, so it was over my head.

I understand the 'grid' that you mentioned now in the GUI.

It only takes about a dozen tries to get things to line up correctly, totals under data that is, so I've got my work cut out for me.

Thanks!


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
quote:


It only takes about a dozen tries


yes, maybe two dozen...




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7