So I have created a cross tab report that based on the information in the query takes any dates found in the query and places the units in that column based on the rows department. I am thinking that report header will not change based on how I have it set up right now. My question is, what is the best way to go about based on today's date have the report change the headers dynamically based on today's date and the future. I want to forecast out based today's date what units are coming on dates and what department they are in. Any help would be appreciated.