[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
NihithaThis 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