March 11, 2011 at 9:44 am
I have an SSRS report with a column which has NULL and Non-NULL Decimal values. In my Value expression in the report, I say if Value is Nothing then 0.00, then in my Format expression, i say, if 0 then "'$' -"
But, when I export that to Excel, it displays just fine, except that when i attempt to Sum a
$ - cell with a cell containing a value, the result is $ -. Which I think means that the type did not carry over.
If my original Database value had been 0.00 instead of NULL, then this would work, but unfortunately, it must be NULL.
I tried the suggestion here:
http://www.sqlservercentral.com/Forums/Topic937897-1063-1.aspx#bm939048
But it didn't work.
Anyone have any ideas?
March 11, 2011 at 10:08 am
I think it means that a $ - carried over instead of a 0.
Is that an actual expression you set up or a currency format? If it is an expression, I would try using the appropriate currency format and see if that works.
March 11, 2011 at 11:22 am
It's a currency format That I use for NULL or 0.00, when it's zero it works fine, but when it's NULL it does not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply