In my SSRS report I want to add a date field that compares last year selected from date and to date versus this year selected from date and to date. For example if selected from date is September 30th I would like to see the data of orders for August 1 to September 30th, 2014 and all the orders for 2013 for that same time period August 1 to September 30th, 2013. I want the report to automatically update so orders that can be compared to the previous year time range exactly. Without having to change the parameters every day for the date to display previous year records
1 Like