Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Iif condition in total by descripion Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 7:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 292, Visits: 1,039
I want o have my total by descripion based on the ISOrder value . If IsOrder = 1 then

"Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : "

ELSE

"Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

I am using the condiion below, but it is not working :

=Iif(Fields!IsOrder.Value, 1,"Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : ","Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

Please help!
Post #1498862
Posted Thursday, September 26, 2013 10:45 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:26 PM
Points: 2,926, Visits: 2,529
try the following:
=Iif(Fields!IsOrder.Value = 1,"Total " & Fields!ProjectName.Value & " by " & Fields!SuppNo.Value & " : ","Total " & Fields!ProjectName.Value & " test by " &Fields!SuppNo.Value & " (excluding charges) : ")

The condition "Fields!IsOrder.Value = 1" was incorrect



Post #1499174
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse