I have a database and table where the dates will change and need the report to reflect the different dates when the report is ran. If I create a report with Titles once it seems would need to rebuild the report each time for the new dates. Is there a way not to have to do this. I am thinking to build a table of the dates and add text fileds to the report to refer to dates but I am also using a crosstab query with the date ranges and would need to line the columns up to the text fields.
May look like this one month with dates as headings
11/30/13 12/31/13 1/31/14
1111 5555 abc
and this the next month
2/28/14 3/40/14 4/30/14
My question is whether I can build one report or if a new report will need to be designed each time.