title: SSRS data comparison report on different dates
body: <p>I am in the process of creating a report that will display sales for different date ranges.  What I mean is that the first column will display data for the date selected by the user.  The next column will display data for that date a week prior and the next one will display data for the previous year's.  The rows are grouped by stores.  What I have done is that I created a subreport which I call with the dates that I need by using the AddDate function.  My problem is that the report has become very slow.  My configuration seems to be good.  I was wondering if anyone has seen this type of situation before and might have some insight or if there might be an alternative way to create these type of reports.  Thanks in advanced.</p>