WinVask -  Faktura

How To: Descending Sort Sequence

How To: Descending Sort Sequence

Previous topic Next topic  

How To: Descending Sort Sequence

Previous topic Next topic  

 

By default a Sorting Band assumes you want to print database information in ascending sequence (0-9, A-Z); there may be times where you need descending sequence (Z-A, 9-0), especially when dates are involved (e.g. print the most recent transactions first, and then go backwards). This is very easy to do:

 

ð        Add a Sorting Band to the report (it is assumed you've already added the Detail band and other information to this report)
ð        Double left click on the Sorting Band to display the Sort Expression dialogue box
ð        Click the Dictionary button to select the database field that you want to use to sort the information; after it is inserted into the Sort Expression entry field you need to add a dash character (-) in front of the database field:

 

frb_bm129

 

ð        As shown in the above screen capture, the database field INV:Date was selected from the dictionary; a dash character (-) was added to the first position of the entry field
ð        Click the SAVE button to return back to the Report Formatter window; in this example, there were three Sorting Bands for the report (and I modified the third Sorting Band); the Report Formatter window now reflects the changed information, as confirmed by the -INV:Date information:

 

frb_bm130