Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Totalling Expressions
Message
De
25/04/2015 12:27:47
 
 
À
25/04/2015 12:24:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Services de reporting
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01619117
Message ID:
01619125
Vues:
24
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform