Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Every person that you meets knows something that you don't; learn from them
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Sort Field with Null Values in SQL Server Reporting Services 2019?

The client was creating a report in SQL Server Reporting Services 2019, and wanted to sort fields within the tablix that contained Null values.


There are a number of methods to resolve this issue, but I found this method quite quick and easy to apply.

Then one can sort on the field by:

  1. In SQL Server Reporting services, add the Tablix/Matrix or List object to the canvas

  2. Add the required fields to the object

  3. Right click on the object

  4. Select the Properties option

  5. In the Properties dialog box, select the Sorting Tab - Add

  6. Press the [fx] button to the right of the Sort By text box

  7. Enter the expression for the field to be sorted on:

    =IIF(IsNothing(Fields!Fieldname.Value), "NULL", "NOTNULL")

  8. Press the OK button

  9. Select the Sort direction

  10. Press the OK button

  11. Run the report

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

5 + 34 =