I have to create a summery report from a detail report. I can hide the colum I don't need, can I hide the row data so only the toal line will display?

This message has been edited. Last edited by: <Kathryn Henning>,

You could always SUM and HOLD so it just displays one line as your totals.. or you could use the ACCORDION report to Expand rows etc.,

Hope it helps!

Or you could just sum the report and exclude the totals row:

TABLE FILE CAR
SUM 
     CAR.BODY.SALES AS 'TOTAL SALES'
ON TABLE PCHOLD FORMAT HTML
END

I got it. thanks
another questions, can I apply the traffic light on grand total? I can do it on subtotal, but not on the grand total.

In InfoAssist I am not sure. In Dev Studio you can always do conditional styling...

I used below code to add traffic light for subtotal, it worked well. but grand total is done on table summerize, I don't know how to apply the traffic light for grand total. I tried change the type to total, it won't work.

thank you for your help!

TYPE=SUBTOTAL,
BY=1,
COLUMN=N7,
COLOR='BLACK',
BACKCOLOR='GREEN',
WHEN=N7 LE .189,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N7,
COLOR='BLACK',
BACKCOLOR='RED',
WHEN=N7 GT .220,
$

TYPE=GRANDTOTAL,...

I tried, it did not work.
below is my grand total code. I don't think grand total is defined webfocus word.

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SUMMARIZE AS 'GRAND TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

more ideas? thank you!

I took it back. it is working.
thanks you Francis!