Focal Point
[CLOSED] Adding columns in the middle of the report when accordion is clicked

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

July 02, 2019, 12:40 PM
Nihitha
[CLOSED] Adding columns in the middle of the report when accordion is clicked
Hello

I am trying to add columns in the middle of the report when accordion is clicked. I have used ON TABLE SET EXPANDABLE ON and it added the required columns at the end of the report. How can I add them in the middle as column 2 ,3 or wherever required?

Thanks in advance

Nihitha

This message has been edited. Last edited by: FP Mod Chuck,


WEBFOCUS, WINDOWS, REPORTS
July 02, 2019, 01:01 PM
BabakNYC
The syntax support 4 possible values:

ON TABLE SET EXPANDBYROW {OFF|ON|ALL|n}

n: Creates an accordion report in which n sort field levels are initially expanded. To roll up an expanded sort field level, click the minus sign (-) next to one of the sort field values on that level.

Maybe instead of ON you can try
ON TABLE SET EXPANDBYROW 3


WebFOCUS 8206, Unix, Windows