[SOLVED] Rowtotal limit

Hi All,

In the below code when I do a row-total it gives me a total of both DEALER_COST and RETAIL_COST. I need only the DEALER_COST ROWTOTAL to be displayed and not the retail cost.
Could anyone please help me with this.

TABLE FILE CAR
PRINT
DEALER_COST
BODYTYPE
RETAIL_COST ROW-TOTAL
ACROSS COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
SIZE=9,
STYLE=BOLD,
$
ENDSTYLE
END

Thanks

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

WebFocus 7.6.6
Unix
HTML,PDF, EXCEL

Posts: 8 | Registered: February 18, 2011

FrankDutch

Virtuoso

posted

Hide Post

Multiverb is the solution

DEFINE FILE CAR
TOTRETAIL=RETAIL_COST;
END
TABLE FILE CAR
SUM TOTRETAIL
BY BODYTYPE
BY CAR
BY MODEL
PRINT
DEALER_COST 
RETAIL_COST 
BY BODYTYPE
BY CAR
BY MODEL
ACROSS COUNTRY
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END

now you get the rowtotal of the retail_cost at the beginning.

	*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

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Show Post

Francis Mariani

Expert

posted

Hide Post

If you add the following to Frank's code, TOTRETAIL becomes the last column.

SEQUENCE sets column order. Documentation: Creating Reports With WebFOCUS Language > Laying Out the Report Page > Arranging Columns on a Page.

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=TOTRETAIL, SEQUENCE=100, $
ENDSTYLE

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Doug

Expert

posted

Hide Post

That's Great Francis,

That put's the total at the end, where one may expect it to be...