SQL Reporting Srvcs - Help with an Expression

JBourne77 · Nov 25, 2009

Question: In Crystal Reports, I had a Formula '@Birth Weight < 1500'

'@Birth Weight < 1500' was set up as follows:

Code:

IF {@Deliveries} = 1  and {aaUDS7;1.BirthWeight} > 0 
and {aaUDS7;1.BirthWeight} < 1501 then 1 else 0

The @Deliveries is set up as follows:

Code:

IF {aaUDS7;1.DeliveryType} <> 'No Entry' then 1 else 0

I would like to build this with the same logic in SSRS. Any insight and help is deeply appreciated!

RiverGuy · Nov 25, 2009

Code:

=Iif(Fields!Deliveries.Value = 1 AND Fields!BirthWeight.Value > 0 AND Fields!BirthWeight.Value < 1501, 1, 0)