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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2012-11-15 : 13:46:11
|
| I am having a problem with Creating Chart. I would like to know how i can change my data if data has no value to 0. Thank You. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-15 : 13:57:25
|
Use an expression such as this:=IIF(Fields!YourDatacolumn.Value is nothing, 0, Fields!YourDatacolumn.Value) |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2012-11-15 : 14:17:59
|
| Awesome. Its working fine. Please guide me. I am having a problem. I have one data set Like below e.gSALES_PERSON,ZIPCODE1,ZIPCODE2,ZIPCODE3,TOTALJIM 0 4 2 6SMITH 2 5 11 18---TOTAL 2 9 13 24Here is the problem. Report runs fine with no problem, but when i see chat doesn't come out right. In display he skip some Sales Man in chart. Is anyone can help me how i can fix this issue. I have total of 22 sales Person in the table...Thanks in advance. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-15 : 23:57:57
|
| whats chart type you chose? have you applied some filters inside chart?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSRS Help..