July 18, 2012 at 5:22 am
I have to create a report which compares the sales for current year and any other previous years.
I need to show in chart.For which I am sure I need to use stacked column.
I have a dataset which is a stored procedure which returns sales amount depending on the ‘Group by’ parameter in the proc, Groupby could be by product, by branch, region. I need to see two columns (series) in the chart for each year.
The proc can produce results for only one year at the time. I have recently started working on SSRS 2008.
I thought I can achieve this by having two datasets pointing to same proc, but one parameter differs i.e current year, and any other year .
But I am not able to choose the series properties, so that they point to one of the data sets. I have searched on google and finally thought to share my doubt. Could you please help me if my question is clear.
So my chart is grouped by product or branch or region. Each ‘groupby’ is further compared for two years.
Thanks
July 25, 2012 at 5:56 am
You can reference fields from other datasets using expressions - something like =(Fields!Sales.Value, "DataSet2011"), but I think you'll be in a world of hurt trying to tie the data back together in a chart.
I'd be tempted to create another proc that returns the 2 years' data in one - will be much easier on you.
As a proc's already written to do one year, the new one could just be a wrapper that calls the one-year proc twice & combines the results.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply