Crosstab query and reports

[tkaplan]

I have a crosstab query that new data is added for every month so the column headings change.

How can i create a report based off of this query without having to go in and update the design of the report every month?

thanks in advance

 

[JoeCruse]

How do you have your column headings set up now? Is it the months of the year, or what? If there is a set total number of column headings, and it's not large, you can put them all in the query as column headings, and then have them all in the report.

You could also do a dynamic crosstab report, which is a little more in depth to do. But with it, you can have a set number of columns on your report, and those column's headings would dynamically change with the query output. Do a search here for more info on them.

 

[tkaplan]

does anyone know a good link that will help me with creating dynamic crosstab reports? i have never done this before and have no idea how to do this.

Thanks in advance.