Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dataset in Custom Code Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 6:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 15, 2013 2:40 AM
Points: 1, Visits: 6
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
Post #1462594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse