How to Display Blanks as Zeros in a SSRS Report

(0) Share

Report

Posted on by sivakumar moorthy

260

Hi all

i need display blanks as zero in ssrs report ,i try this

=IIF(IsNothing(Fields!MyField.Value), 0, Fields!MyField.Value)

but is show only one zero like this 0,i need like this  0.00 any one help to bring like this 0.00

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi sivakumar moorthy,

Please create a new ExtendedDataType with 2 number of decimal. and add that EDT to your "MyField".

It will workout for sure.

Thanks,

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi sivakumar moorthy,

You can set format on the cell to "F2" or use this expression

=Format(Fields!MyField.Value,"F2")

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can use FORMAT function to format numbers, e.g. =Format(Fields!MyField.Value,"0.00").

It would be also useful to know the type of your field. I assume it's a real number, but who knows?

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report
Copy link

Link copied!

Hi all, How to do the same in Morphx report??

How can i show 0.00 in the Morphx Report, if the value is null it shows blank but instead i need to display in my report as 0.00..

Pls Advice

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Rusty Ryan,

Based On EDT we can print zero value with 0.00.

Thanks

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report
Copy link

Link copied!

Try this please,

Was this reply helpful? Yes No