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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 5:22 AM
Points: 300, Visits: 1,070
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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:56 PM
Points: 3,033, Visits: 2,636
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