Hi,

Run the sample code below.

SET EXPANDBYROW=ON
TABLE FILE GGSALES
SUM BUDUNITS UNITS BUDDOLLARS DOLLARS
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,$
END

If you expand the data, it moves to right and left. I would like to have fixed column width. How can I do that?

Thanks

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

Have you tried added "ON TABLE SET EXPANDABLE ON" after "ON TABLE SET HTMLCSS ON" as per F1 (Help)?

Keep in mind that the following commands are not supported when using Accordion Reports:

BORDER, COLUMN, FOR, IN, OVER, PAGE-NUM, ROW-TOTAL, TOTAL

Thanks Doug.

I tried your suggestion but no luck.

SET EXPANDBYROW=ON
SET DROPBLNKLINE=ON

TABLE FILE GGSALES
SUM BUDUNITS UNITS BUDDOLLARS DOLLARS
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET HTMLCSS ON
ON TABLE SET EXPANDABLE ON
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,$
ENDSTYLE
END
-EXIT

Hi Kamesh,

Thanks for posting this, I've had the same question.

I think a reasonably good analogy, for the user experience we are looking for, is Windows Explorer. Clicking various nodes in the left-hand side hierachy, doesn't cause the 'Name/Date Modified/Type/Size' columns to shift left and right.

In the GGSALES example, the 'dollar' columns will shift left and right, as a function of what is clicked in the hierarchy.

Dave

I rewrote my code using an JQuery TreeTable and it works good.