Want NULL value of date type column at last when ordering data in report

• virenkumar.patel

  SSC Veteran

  Points: 281

  More actions

  June 14, 2013 at 7:29 am

  #273837

  Hi,

  I am using SSRS 2008 R2. Dataset has date field "MyDate". "MyDate" field contains NULL(nothing) values. I am doing sorting on different fields. I am able to sort data with "MyDate" fields also.

  Issue : I want Null(Nothing) data at end of list for "MyDate" field sorting. How it will possible. Order

  Please provide me solution if anyone have.

• PhilPacha

  Hall of Fame

  Points: 3645

  More actions

  June 14, 2013 at 7:47 am

  #1624118

  Off the top of my head...

  In the ORDER BY clause, immediately before the 'MyDate' column, add this CASE statement:

  CASE WHEN MyDate IS NOT NULL THEN 1 ELSE 2 END

  That will cause the non-null entries to be returned first, followed by the null entries.