In a sales report I want to enter a date range from two DB fields used in a formula and then list two columns of results that list the results from the date range entered, as well as a comparison column of data from exactly one year previous. I'd like them to be listed side by side. Would I use a Subreport for the comparison data? And if so, how would I take the entered date range and have the Subreport use data from the previous year? I want only one prompt for a date range and have the report handle pulling data from the previous year for the comparison.
LEAD SOURCE CURRENT DATE RANGE: LEAD SOURCE ONE YEAR AGO:
Lead Source: (formula 1) Sales TTL: (formula 2) Lead Source: (formula 1) Sales TTL: (formula 2)
I hope this is clear enough to follow, and thanks for the help!