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"
KerrieS
Member
25 Points
5 Posts
Reporting Services Count
Jul 13, 2005 07:37 PM|LINK
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
ndinakar
All-Star
49092 Points
6868 Posts
Moderator
MVP
Re: Reporting Services Count
Jul 14, 2005 11:47 PM|LINK
=Count(iif(Fields!act_shp_dt.Value > Fields!prm_shp_dt.Value, 1, 0))
Dinakar Nethi
Life is short. Enjoy it.
***********************