Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Detailed Guide to DevExpress Reporting > Provide Interactivity > Sort a Report in Print Preview
All docs
V23.2
Reporting
Product Information
.NET / .NET Core Support
Get Started with DevExpress Reporting
Create Different Report Types (Walkthroughs)
Detailed Guide to DevExpress Reporting
Introduction to Banded Reports
Bind Reports to Data
Use Report Controls
Use Report Parameters
Shape Report Data
Use Custom Fonts
Arrange Dynamic Report Contents
Customize Appearance
Add Navigation
Provide Interactivity
Create Drill-Down Reports
Sort a Report in Print Preview
Edit Content in Print Preview
Print Preview Mouse Events
Create Drill-Through Reports
Obtain a Label's Text in Print Preview
Add Extra Information
Merge Reports
Use Expressions
Store and Distribute Reports
Globalize and Localize Reports
Reporting API
Localize Reporting Applications
Security Considerations
Visual Studio Report Designer
VS Code Report Designer
Reporting for Desktop
Reporting for .NET MAUI
Reporting for Web
Cloud Integration
Cross-Platform .NET App UI
Backend Web API Service / REST API for Reporting
WCF Report Service
End-User Documentation
Redistribution and Deployment
API Reference
ASP.NET Core API Reference
Blazor API Reference
Client API Reference
Client API Reference (Web Forms & MVC)
Download CHM

Sort a Report in Print Preview

  • 2 minutes to read

This tutorial illustrates how to enable sorting report data in Print Preview without writing any code.

Note

Watch the Video: Reporting: Print Preview Sorting (YouTube)

In this tutorial, we will start with the following report displaying products grouped by category names.

interactive-sorting-starting

You can implement interactive sorting for both the detail data and report groups.

Tip

The created report is platform-agnostic and its interactive features are supported by the Print Preview available for all application platforms.

Sort Report Groups

To enable sorting report groups in Print Preview, select the label displaying product category names located in the Group Header and switch to the Properties window.

interactive-sorting-header

Expand the label’s XRLabel.InteractiveSorting property, and set the SortingOptions.TargetBand property to GroupHeader1 and SortingOptions.FieldName to CategoryName.

Switch to the Preview tab to sort report groups by the CategoryName field. When a mouse pointer hovers over the category name, it changes to a hand indicating the sorting capability. The arrow displayed at the element’s right edge indicates the sorting order.

interactive-sorting-header-result

Sort Detail Data

To enable sorting data in the Detail band, select the table cell displaying the Product Name title and switch to the Properties window.

interactive-sorting-detail-sort-fields

Set the SortingOptions.TargetBand property to Detail and access the SortField property.

In the invoked collection editor, add a new group field and set its GroupField.FieldName to ProductName.

Set the SortingOptions.FieldName property of the table cell to the ProductName field.

interactive-sorting-detail-field-name

On switching to the Preview tab, you can now sort data in the Detail band by the ProductName field.

interactive-sorting-detail-result

If you provide interactive sorting to multiple fields, clicking another field clears all the previously applied data sorting. Hold the SHIFT key while clicking to preserve the existing sorting settings and thus sort against multiple fields.

To disable data sorting against a specific field, hold the CTRL key on its caption click.

Note

Reports embedded into the current report using the XRSubreport control do not support interactive data sorting.