jeudi 5 novembre 2015

SSRS Expression in field using IN

Vote count: 0

I am trying to filter the data returned in a field using multi-value parameters. I need to filter based on 3 conditions:

--Before a Warranty End Date

--AND Service Type on the record must match one of the MULTI-VALUE parameters selected by the user

--AND Order Type on the record must match one of the MULTI-VALUE parameters selected by the user

Currently, this works for the first selection I described above (to sum only those records with a service date <= warranty end date , however, I cannot get the syntax to also check the 2 other fields based on the parameters selected...

Sum(iif(Fields!FirstServiceDate.Value <= Fields!WarrantyEndDate.Value, CDbl(Fields!ExtendedCost.Value), CDbl(0)))

asked 1 min ago
Liz
1

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at http://ift.tt/jcXqJW.



SSRS Expression in field using IN

Aucun commentaire:

Enregistrer un commentaire