?
Solved

SSRS Sum an Expression

Posted on 2014-08-11
5
Medium Priority
?
2,487 Views
Last Modified: 2014-08-22
Hello Experts Exchange
I have a report with several  expressions I want to sum up the expression at the bottom of the report.

I have created a new expression with the follow formula;
=Sum(ReportItems!Textbox2.Value)

But this does not work.

Is there a way to calculate the expression totals?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
  • 3
4 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40252619
Hi,

This will give you total for Single Textbox so this will not do.

If you want total for Row you can add row group and for column total you can add column group

In column group total you can specify the Column name (ReportItems!Textbox1.value + ReportItems!Textbox2.value) etc
0
 

Author Comment

by:SQLSearcher
ID: 40253017
Hello Vikas Garg
I want to calculate the running total of a field that is a expression calculation, the example you have given me will only add two fields together.

Regards

SQLSearcher
0
 

Accepted Solution

by:
SQLSearcher earned 0 total points
ID: 40255062
Hello
To solve the problem I had to make all my expression calculations into a Calculated Field under my dataset, I was then able to sum the totals of my expressions.

Regards

SQLSearcher
0
 

Author Closing Comment

by:SQLSearcher
ID: 40264831
Hello
Was able to resolve the problem by my self.

Regards

SQLSearcher
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

862 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