Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Expensive equipment will make up for the lack of talent or practice
 
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!!!!

25
February

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.



Solution:

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

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

56 + 13 =