Dataset in Custom Code

• adigda

  Grasshopper

  Points: 11

  More actions

  June 12, 2013 at 6:39 am

  #295164

  Hello,

  How to calculate the formula Sum([PRODUCT_VAL] ) for Distinct( [ID]) in SSRS? ( [PRODUCT_VAL] and [ID] - are two columns in the dataset )

  I think I need to iterate through rows of DataSet in custom reports code, to find Distinct - [ID] and make SUM of theirs [PRODUCT_VAL] , but is it possible?

  Or is it a better solution?

  Thanks