I need to edit an existing report that includes sales and tons sold based on a record selector defined by a parameter DateRange. The current report runs like a champ. Now, I am being asked to write reports that will allow the existing data and then include 1 month prior. A second report 2 include quarters and a third to include 6 mos.
First things first, I have a perfectly good working report based on a date range and I want to still include that data and then just add 1 prior month. I have tried DateAdd and LastFullMonth, but both seem to run me around in circles. They complain that a Date Range is required and when I change it to DateRange the complaint is that a date/time is required. Also, with LastFullMonth I receive a Boolean error.
Is there an easier way to do this, sure seems like there should be?
Should I just define one parameter of Date; however, when I do this I lose the current data?