Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Totalling Expressions
Message
From
25/04/2015 12:27:47
 
 
To
25/04/2015 12:24:46
General information
Forum:
Microsoft SQL Server
Category:
Reporting Services
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01619117
Message ID:
01619125
Views:
26
>>>I have an SSRS report with a table that shows two numeric columns and the difference between them
>>>I'm using the report builder that comes with VS 2013. It's a local report associated with a Winform app.
>>>I wanted to sum the differences and couldn't see a straightforward way to sum an expression.
>>>
>>>I found some convoluted solutions on the web but decided instead to add a computed column to the dataset and used that.
>>>
>>>Is there a better way?
>>
>>You could also sum differences this way...
>>
>>SUM( Fields!Value1.Value) - SUM( Fields!Value2.Value)
>
>Hmm that seems awfully easy. I can't believe I didn't try that.
>If put that expression in a text box on a row that was part of a group, would the SUM() follow the rules of the group?

Yes, it should. If it doesn't, let me know.

Taking the family to Rainforest Café in Edison later today. Haven't been to one of those in over 10 years.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform