Sort Data

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.5 u5 > Dashboards and Reports Customization Guide > Designing Reports > Shape Report Data > Group and Sort Data 

Sort Data

Sort a Report's Data

Do the followebg to sort data in your report:

 

1.Create a new or open an existing data-bound report.
You cannot apply sorting unless your report is bound to a data source.

2.Switch to the Properties panel and select the Detail band. Select the Sort Fields section in the Actions category and add a new sort field to sort the report's data by the required data field.
 
eurd-web-sort-data-select-field
 

papercliper

Note:

See the Sort Data by a Custom Field tutorial to learn how to sort a report's data by a custom field.

 

This adds a corresponding sort field to the Sort Fields collection. You can access this collection by expanding the sort field section.

 

3.Click the Up or Down buttons to define the sort order within the group (ascending or descending). Use the DisableSortingh button to disable sorting in grouped data.
 
eurd-web-sort-data-sort-order
 

4.When a report has multiple sort fields, you can change their order by clicking Move Up or Move Down.
 
eurd-web-sort-data-move-up-and-down
 

5.Drag the corresponding field from the Field List onto the report area and switch to Print Preview to see the result.
 
eurd-web-sort-data-result
 

Interactive Sorting in Print Preview

You can allow sorting report data directly in Print Preview by clicking a designated element.

 

eurd-web-sort-data-in-print-preview

 

See Sort a Report in Print Preview for more information.