Thank you Razzak I just had time now to check it and to look again in RDoc and sure enough its there. I had triple checked RDoc before putting my post but missed it! Manuel
On November 1, 2015 6:43:01 AM PST, "A. Razzak Memon" <[email protected]> wrote: >At 07:31 PM 10/31/2015, Manuel de Aguiar wrote: > >>Is there a way to capture the user selected sort order? The user >>is able to change the sort order by clicking on the colums' header. >>I need to capture it so the generated report can have the user's >>selected sort order. I thank you for any help you may give. > > >Manuel, > >Yes, there is a way to capture the user selected sort order. > >For Variable Lookup ListView control, you can use the "CURRENTSORT" >property to capture the current sort. > >Here's how: > >01. Assign a component ID to Variable Lookup ListView control, > such as "VarLookupListView". > >02. Make sure that the user is allowed to sort the column > > Variable Lookup ListView Control > Properties ... > > [x] Column Sort > >03. Place a button control to get the property of current sort > > Use the following command as "On-Click EEP": > > SET VAR vCurrentSort TEXT = NULL > GETPROPERTY VarLookupListView CURRENTSORT 'vCurrentSort' > RECALC VARIABLES > RETURN > > You may also use the same code prior to printing the report. > > Resulting variable "vCurrentSort" will return the currently > clicked column name and the sort order, such as: > > columnname ASC > columnname DESC > > For example: > > If the column CustID header was clicked once, the resulting > variable would be: > > CustID ASC > > If the column CustID header was clicked again, the resulting > variable would be: > > CustID DESC > >That's all there is to it! > >Feel free to reach out to me if you need a sample form that illustrates >the use of such feature. > >Very Best R:egards, > >Razzak. -- Sent from my phone. Please excuse my brevity.
