CODEWITHSUNDEEP
reporting-servicesaxaptadynamics-365-operations
jhowe
jhowe

Reputation: 10848

SSRS complex IIf expression

I'm stuck on an expression. Below is programmatically what i want to do, but SSRS is not having it... How can I get this to work? 

=IIf(Fields!TransTypeLabel.Value = "Hour", Fields!SalesAmount.Value, IIf(Fields!TransTypeLabel.Value = "Fee" AND Fields!CategoryId.Value = "TIME_FEE", Fields!SalesAmount.Value, 0), 0)

Upvotes: 1

Views: 350

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21703

ake the final " , 0" out (but not the end brace). You also have missed .Value (or .Label depending on what you actually want) from the end of some field references. e.g. Fields!TransTypeLabel should. be Fields!TransTypeLabel.Value . Or maybe that was a type and should have read Fields!TransType.Label ?

Upvotes: 1

Related Questions