YTD and Current Period SubTotals against a Progress Database

• Steve Hindle-535638

  SSCrazy

  Points: 2378

  More actions

  April 7, 2010 at 4:03 am

  #217534

  I am trying to display a YTD cost and Current Period cost on the same report against a Progress database. Because of syntax issues I cannot use:

  CASE Period WHEN @Period THEN Cost ELSE 0 END.

  in then SQL.

  Alternatively, I have tried to do this on the fly within the report using an expression:

  =IIf(Fields!period.Value=Parameters!Period.Value,Sum(Fields!job_cost.Value),0)

  but this just sums YTD - maybe due to a scoping issue.

  Is there a way I can get the report just to sum the cost for period selected as well as the whole YTD?

  Thanks

  Steve

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  April 7, 2010 at 8:22 am

  #1147369

  I am not in a position to test this, but I think you can add a scoping component to your sum where the scope is the grouping you are referring to.