Accordion report total column of by only

Focal Point

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

May 17, 2006, 01:41 PM

Accordion report total column of by only

Built an accordion report that has
by, by, by, detail detail detial

I would like to sum the column of the first and second detail but it needs to break per by. Is this possible in an accordion report?

May 17, 2006, 02:14 PM

Go it, Don't know how to explain it yet will just show you the code.
SUM
2Premium/D20 AS '2004'
2Count/I5 AS 'Count'
1Premium/D20 AS '2005'
1Count AS 'Count'
Premium/D20 AS '2006'
Count AS 'Count'
BY BR
BY Class AS 'Contract Class'
BY City AS 'City'

ON Class SUBTOTAL AS '*TOTAL'

May 17, 2006, 03:38 PM

Prarie

IF you want to Subtotal the first 2 columns you would put

ON Class SUBTOTAL 2PReMIUM 2COUNT

I assume you are on version 7 ..so don't know if an accordion report would act any different.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

May 17, 2006, 06:09 PM

Tony A

Yes, perfect for an accordian report. Just code a multi level report -

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
SUM RCOST DCOST
BY COUNTRY
BY CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDABLE ON
ON TABLE SET HTMLCSS ON
ON TABLE etc. etc. etc.
END

Notice that the BY phrases are repeated for each level.

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10