Column with Zero values returned as False

• ajashadi

  Ten Centuries

  Points: 1017

  More actions

  March 28, 2006 at 9:02 am

  #171027

  Hi,

  I have a very basic report and I tested the SQL query in Query Analyser and works fine... But when I tried to run same query by creating a report, one of the columns which returns 0 is returning 'false' as output instead of 0... I dont know why this is happening..

  Any suggestions are welcome.

  Thanks in advance.

• Mike Kendall

  SSC Eights!

  Points: 958

  More actions

  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

   

• Ramya Tummala-311208

  Valued Member

  Points: 71

  More actions

  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