Post reply

ssrs null values

  • August 28, 2012 at 2:27 am

    #266027

    hi friends i have small data in sssrs .plz tell mehowto solve this issue

    how to handle nulls data in ssrs reports

  • August 28, 2012 at 2:33 am

    #1530625

    If you are using a SQL statement as your dataset wrap the column(s) in an ISNULL() or a COALESCE()

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • September 4, 2012 at 3:25 pm

    #1533544

    I agree with Andy. Also, in some cases I've had to put the SQL statement in a common table expression and check for nulls with a CASE statement. I guess if it is SQL then you could post the query and we could look at it.

  • September 6, 2012 at 1:21 am

    #1534268

    which version you are using

    there is direct solutuion in ssrs 2008 R2

  • September 7, 2012 at 9:23 am

    #1535130

    sql server 2008

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply