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 ValuesEven 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
Perfect. Thank you for posting.
ReplyDeletePerfect. Thank you for posting.
ReplyDeletean 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