CODEWITHSUNDEEP
ssrs-2008reporting-services
DiningPhilanderer
DiningPhilanderer

Reputation: 2767

SSRS 2008 R2 - Add total line to chart

I have created a line chart that displays the different types of messages sent over a month (Email, Print, Voice) which are displaying on the chart just fine.
Is there an easy way to add another line which totals the values for the 3 series without changing the SQL?

Upvotes: 2

Views: 8494

Answers (1)

Fillet
Fillet

Reputation: 1426

There are two way to do this in reporting services:

1. Directly in the chart

Add a new series to your line chart. Set the expression for the value to be

=Fields!Email.Value + Fields!Print.Value + Fields!Voice.Value

2. With a calculated field in the dataset

Set the calculated field "AllMessages" to be the sum of Email, Print and Voice. Then add AllMessages to your chart. Youtube Walkthrough calculated field

Upvotes: 5

Related Questions