SQLServerCentral.com / Reporting Services / Reporting Services 2008 Development / Want NULL value of date type column at last when ordering data in report / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 17:20:06 GMT20RE: Want NULL value of date type column at last when ordering data in reporthttp://www.sqlservercentral.com/Forums/Topic1463563-1633-1.aspxOff 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 ENDThat will cause the non-null entries to be returned first, followed by the null entries.Fri, 14 Jun 2013 07:46:59 GMTPhilPachaWant NULL value of date type column at last when ordering data in reporthttp://www.sqlservercentral.com/Forums/Topic1463563-1633-1.aspxHi,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.[b]Issue [/b]: I want Null(Nothing) data at end of list for "MyDate" field sorting. How it will possible. OrderPlease provide me solution if anyone have.Fri, 14 Jun 2013 07:29:06 GMTvirenkumar.patel