Thursday 17 May 2018

Replace Zero with Blank or Dash in SSRS

Here is the solution to replace zero with the Blank(' ') or Dash(-)

select textbox and check the properties on right side pan as shown in image.

for blank use below format
''0.00;(''0.00);''

for dash use below format
''0.00;(''0.00);'-'

No comments:

Post a Comment