Link to home
Start Free TrialLog in
Avatar of marvo2010
marvo2010

asked on

Custom Assembly that can Sum up the values in a whole column and return that value

Hello,

I have a need for someone who can help me  with a custom function in c# that can sum up all the values (interger) in a single column of a report in SSRS and return that sum value in every row of another  single column from which the function is called dynamically as the report is generated.

this will be a simple function that I will register as an assembly and call it withing the report in ssrs.

Thanks
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

I don't think you need an assembly for a simple function like this. You could just add the code to the report directly. But I also think you don't need a custom function for this. The Sum function has a scope parameter. You can use this to return the total of a single column.
If you had a report with column A that contains 10 rows with integer values and next to it column B with 10 rows containing the sum of all the 10 values of column A, would that answer your question. Or are your requirements more complex than that?
Avatar of marvo2010
marvo2010

ASKER

yes thats what I am looking for.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial