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
marvo2010Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nico BontenbalCommented:
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?
0
marvo2010Author Commented:
yes thats what I am looking for.

Thanks
0
Nico BontenbalCommented:
In column 'B' you can use:
=Sum(Fields!A.Value,"Dataset")

Open in new window

Replace A with the column name you want to sum. Replace Dataset with the name of the dataset. For more information see:
http://msdn.microsoft.com/en-us/library/dd283120.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.