Skip to Content
0
Former Member
Oct 11, 2013 at 03:08 PM

Changing Group Sort at runtime "!"

450 Views

The group band syntax has this nice little property which is set in the DWO painter on the Group Header property sheet

group(level=1 header.height=0 ..... trailer.gradient.spread="100" sort="report_name A " )

Requirement is to change the group sort value at runtime to support column header click sorting when the detail band is collapsed and only group 1 band is visible

Funny but there is no online help for the group.x.sort property.

messagebox('value', describe( 'datawindow.header.1.sort' ) )

//returns ! == If the property list contains an invalid item, Describe returns an exclamation point for that item

Of course modify returns a syntax error too!

Changing the Table.Sort property is not useful in this case, as I need to sort groups not rows

Of course SetSort( ) and Sort( ) are equally not useful in this case

Short of a multi DWO solution or changing to SQL grouping. Am I missing something?

TIA

Yakov