I have created a report with 4 separate tables, each pulling the same data, but each with a different date range. I did this by setting up 4 separate date range user inputs. So each time I run the report, I have to enter 8 different dates, which is tedious. What I would like to do is set the first two dates, i.e. June 1 and June 30, and have the next table be set so its date range dates are June 1 minus 1 month and June 30 minus 1 month. Does anybody know how to do this, or if it is possible?

FYI, the report is telling me when business is booked for a particular month. I.e., for the month of June 08, how much of that month's business was booked in June 08, May 08, April 08, etc.

Thanks,

Ross

You're going to need to use fscript to generate the other dates.

For example:
--------------------

startDate := element valueForKeyPath:'userInput.startDate'.
newStartDate := startDate dateByAddingYears:0 months:1 days:0 hours:0 minutes:0 seconds:0.

--------------------

This will create a new date by adding a month.

You'll then need to add the key to the reportlayout so you can pull it from anywhere in the report
--------------------
(element enclosingReportLayout) setReportData:newStartDate forKey:'dateOneMonthAdded'.
--------------------