show decimals

• varunkum

  Default port

  Points: 1481

  More actions

  March 16, 2011 at 3:49 pm

  #233341

  Hi i have values like 0.123242575676563423,0.1,0,1.340534095803,0.343434,0.454564,2.34534534546546 in my output for a SQL statement. But they show blank in ssrs. Is there a way to make them show. Thanks in advance.

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  March 18, 2011 at 7:30 am

  #1300493

  Hi,

  You can provide a little more detail, Query may be.

  But one thing which you can check straight away is textbox properties in SSRS.

  Right click on textbook, go to 'Textbox Properties' and in the Number tab, Select 'Number' and decimal places to be, say 2 or 3.

  Check this if works. Though there could be many other reason eg NULL value somehow coming in the Query, Null appears as blank.

  Athar.