Reporting Services Count RSS

• • Reply
  

  KerrieS

  Member

  25 Points

  5 Posts

  Reporting Services Count

  Jul 13, 2005 07:37 PM|LINK

  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

• • Reply
  

  ndinakar

  All-Star

  49092 Points

  6868 Posts

  Moderator

  MVP

  Re: Reporting Services Count

  Jul 14, 2005 11:47 PM|LINK

  perhaps something like this :
  =Count(iif(Fields!act_shp_dt.Value > Fields!prm_shp_dt.Value, 1, 0))
  
  ***********************
  Dinakar Nethi
  Life is short. Enjoy it.
  ***********************