Hello,

When I apply EXPANDBYROW to create an accordion report it is adding a total across the top against each grouping on the BY field. A total is not needed anywhere in this report, is there a way to supress this?

Thanks

Code below:

TABLE FILE SQLOUT

PRINT
Contact_List_Name AS 'Contact List Name'
List_Status AS 'List Status'
Pass
Initial_Records AS 'Initial/Add Count'
Currently
Avail_30 AS '30 Mins'
Avail_60 AS '60 Mins'
Avail_60Plus AS '60+ Mins'
Timezone_Not_Available AS 'TZ Not Available'
Total
Abort_Rate AS 'Abort Rate'
Last_Updated
BY Segment
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDBYROW ALL
ON TABLE NOTOTAL
ON TABLE SET CSSURL '/approot/style/opera.css'
ON TABLE SET STYLE *

This message has been edited. Last edited by: <Emily McAllister>,

Thanks for the reply. So there's no way to hide this in webfocus?

Its automatic, as the manual states...
Change all your numeric fields to alpha using FPRINT and right justify using RJUST.
Search on FPRINT. May work, don't know???

Thanks, I'll give it a go

amdev,

Just something to note. EXPANDBYROW is basically an adaptation of SUBTOTAL. So you can use subtotal syntax to manipulate it. Also there are some tricks you can do using multiverbs and stuff like that.