Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Spark line in SSRS

Author  Topic 

kishoremcp
Starting Member

41 Posts

Posted - 2013-10-09 : 13:08:04
Hi,

I have 13 months data in a table. Rows(Months) and 6 Fields in Column.

I am having 12 months average using the below expression.
=(Fields!ID12_Month_Average.Value)
Here I am calculating the average in SQL Query.

What I want is a sparkline which shows only last 12 months values.
Average = sum(values)/12 where month key is between last month and last 12 months (Ex: Oct-12 to Sep-13).

Is it possible in SSRS. If so please help me..



Regards
Kishore
   

- Advertisement -