Search This Blog

SSRS Order BY with Null Statement

             Order by Issue with Null Values in SSRS

There have been Situation where u have to order a column in SSRS but it contail Null Values
Even after sorting them A-Z the Null Values will Come first

In This type of Scneraio
Select Tablix Properties-Sorting-Order by
in Expression Write the Below Expression

=IIf(IsNothing(Fields!TerritoryGroup.Value), "NULL", "NOTNULL")

Note: If you have any group in your report Go to Group Properties -Sorting-Order by
and Remove default order by which is A-Z

3 comments:

  1. an established Internet marketing organization based in the United Kingdom is expanding their services to include Affiliate Online Marketing Business sites by acquiring the YBIS organization. managed technology solutions

    ReplyDelete