Post reply

Column with Zero values returned as False

  • March 28, 2006 at 5:46 pm

    #629326

    This would be the expected result when your data type is BIT.   You can try modifying the query / sproc to force the value as an INTEGER.

    CONVERT(INT, data_value)

    Good luck

    Mike

     

  • March 29, 2006 at 2:48 pm

    #629662

    You can even change on the report like this...

     

    IIF(Fields!YourColumnName.Value = "false",0,Fields!YourColumnName.Value)

     

    Ramya

Viewing 2 posts - 1 through 3 (of 3 total)

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