how do i sum multiple fields in ms sql reporting services

Posted on 2006-04-04
Medium Priority
Last Modified: 2012-06-27
for example i have fields1, fields2 etc..

In an expression how do I add these all together

I need currency format..

Question by:LHood1
1 Comment
LVL 14

Accepted Solution

simon_kirk earned 2000 total points
ID: 16398825
If they are within the same dataset just add an expression to the table cell:

=Fields!MYFIELD1.Value + Fields!MYFIELD2.Value + Fields!MYFIELD3.Value ...

Depending on your data you might need to use the SUM function =Sum(Fields!MYFIELD1.Value) + ...

Then just format the cell as Currency (Format=C2)

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month13 days, 20 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question