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 |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2006-12-22 : 13:24:56
|
Hello,This is the other part that I need:=Sum IIf(Fields!VendorId.Value = 7,(Fields!LeadCount.Value),0)) Peso or someone out there can you tell me what I did wrong here?Thanks,Kurt |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 13:44:57
|
| =Sum(IIf(Fields!VendorId.Value = 7,(Fields!LeadCount.Value),0))perhaps? |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-12-22 : 13:53:45
|
Hello Peso,I think I might have just made your proud!Here is the correct answer!=Sum(IIf(Fields!VendorId.Value = 7,(Fields!LeadCount.Value),0)) With the help from you on the other part, I think I am on my way to gettting this report done!Maybe this was my Christmas present?Merrry Christmas everyone,Kurt |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-22 : 23:25:08
|
quote:
Originally posted by kdnichols
Hello,This is the other part that I need:=Sum IIf(Fields!VendorId.Value = 7,(Fields!LeadCount.Value),0)) Peso or someone out there can you tell me what I did wrong here?Thanks,Kurt
1 You can notice that there is mismatch at the number of opening and closing braces2 When you ask can you tell me what I did wrong here?, also post the error message you gotMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
IIf Condition almost there I think