Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dba123
Yak Posting Veteran
90 Posts |
 Posted - 2006-02-21 : 22:41:21
|
| In my SSRS 2005 Report, after I added the Round function, whenever the expression results in zero in the end result, it shows nothing in the report...when it should show zero.For example, I have this expression for one of my fields in my SSRS 2005 table:=Round(((Fields!FeeGoal_IL.Value) / IIf(Fields!FeeSchedule.Value = 0, 1, Fields!FeeSchedule.Value)) * 100)it's rendering nothing because it's zero....if I take the round off, I get 0.00.I need to be able to round but it's causing issues. I can't round before I bring the values from SQL into my report because the end result needs to be rounded, not each value in the group.why does Round do this? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-22 : 05:40:05
|
| It's probably not ROUND....have you 'suppressed zeros' in the style that EXCEL does it? |
 |
|
|
dba123
Yak Posting Veteran
90 Posts |
Posted - 2006-02-22 : 08:07:22
|
| correct, it wasn't round. I had changed the format to #,####. I changed it back to N0 and now it does the same as #,#### but shows zero again. Thanks. |
|
|
|
|
|
|
Round function returning nothing for zero