Need CrossTab Style Report

[bconner]

I have a Cross Tab Query that will Trend Calls by Month. I would like to be able to create a Report where the Months will Trend out as Columns. The report will need to be able to grow (Pick up New Months as the Data is entered) because I only have Jan - Feb data. Is this possible? I don't want to have to add the New Month to the Report manually each Month.

 

[bconner]

Ok, I figured it out... If I add In(1,2,3,4,5,6,7,8,9,10,11,12) after the Pivot Function it Works!