Reporting Services Count

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.comYou'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.
"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
--
You did IT!!!!!!!!!!!!
Thank you SO MUCH, Kerrie
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200507/1