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 |
|
swsmoore
Starting Member
5 Posts |
 Posted - 2009-02-19 : 18:19:00
|
| I have a textbox with an expression that works in a report with only one dataset. I am unable to modify it to specify the dataset so that works in a report with multiple datasets.This is the one that currently works:=sum(IIF((Fields!PaymentAmount.Value)<>0,CDec(0),(Fields!Approved.Value)))When I modify it to look like this, the report crashes:=sum(IIF((Fields!PaymentAmount.Value, "ClaimInfo")<>0,CDec(0),(Fields!Approved.Value, "ClaimInfo")))The error message I get is: Argument not specified for parameter 'FalsePart' of 'Public Function IIf...'Can anyone help me?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-20 : 12:26:20
|
| use like this:-=sum(IIF((Fields!PaymentAmount.Value)<>0,CDec(0),(Fields!Approved.Value)),"ClaimInfo") |
 |
|
|
swsmoore
Starting Member
5 Posts |
Posted - 2009-02-20 : 16:23:39
|
| It works. Thank you very much. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-21 : 02:43:31
|
welcome  |
|
|
|
|
|
|
Help with IIF expression