"Kerrie S via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:5145CB76A8536@SQLMonster.com...
> Hi All,
> I am trying to compare two dates: actual shipping date > promise shipping
> date.
> If the sctual shipping date is greater that the promised shipping date
> than
> count that order number if not than it is null.
>
> This is in the report designer in the "edit expression"
>
> =Count(iif(Fields!act_shp_dt.Value > Fields!prm_shp_dt.Value,
> Fields!ord_nbr.
> Value, ""))
>
> It is counting everything as true.
> Can anyone help me.
>
> Thanks, Kerrie
>
>
> --
> Message posted via http://www.sqlmonster.com

goodman93 wrote:
>You're on the right track, but rather than using a count, try the following
>with a sum.
>
>Create a non-visible textbox with the following expression:
>=iif(Fields!act_shp_dt.Value > Fields!prm_shp_dt.Value, 1, 0)
>
>Then create a summary field that calculates a sum of the above values.
>
>> Hi All,
>> I am trying to compare two dates: actual shipping date > promise shipping
>[quoted text clipped - 13 lines]
>>
>> Thanks, Kerrie