Hi All,

This is an issue I am facing with the expandable option in WebFOCSU710. The following is the sample code for report.

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
BY CAR
BY SEATS
ON TABLE SET EXPANDABLE ON
END
-EXIT

I want the retail cost to be displayed by region first and when it is expanded, display by Region and Car etc. Currently the retail cost will be displayed only when the node is expanded to the last level.

You can express a query in Focus in multiple sentences. Each sentence makes one 'expandable' panel. e.g.
TABLE FILE CAR
SUM RETAIL_COST BY COUNTRY
SUM DEALER_COST AND RETAIL_COST BY COUNTRY BY CAR
SUM SALES AND RETAIL_COST BY COUNTRY BY CAR BY MODEL
ON TABLE SET EXPANDABLE ON
....
END

Yes that is correct. But the thing is that when the 'RETAIL_COST' is displayed by the second level, I dont want it be displayed again in the first level. In a general tree report, once the node is expanded, the data will be seggregated by the next level and not again by the previous level. I am not sure whether this is possible But if anyone has a method to do this please share....

TABLE FILE CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR
SUM RETAIL_COST DEALER_COST SALES BY COUNTRY BY CAR BY MODEL
ON TABLE SET EXPANDABLE ON
END
-EXIT

Is there a way for the columns to not repeat with every expansion level and for the multiverb accordian report to work more in line with how the subtotals in Excel work (as asked for by Cyril). Thanks!