Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Adding columns in the middle of the report when accordion is clicked
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Adding columns in the middle of the report when accordion is clicked
 Login/Join
 
Member
posted
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
 
Posts: 14 | Registered: May 07, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 8204, Unix, Windows
 
Posts: 1614 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Adding columns in the middle of the report when accordion is clicked

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.