Help with report design

[stevekos07]

Let me see if I can explain my problem. I have a crosstab query that displays information by month in columns as new data is added to the underlying table. For example, as may 2017 data is added, the crosstab query will create a column May-17, and as June data comes into being it creates that column in the query output.

I have designed a report that displays these columns, but I find that new columns must be created in the report each month because these are not created dynamically as they are in the crosstab query.

Can I create a report that dynamically displays this new data as it is created so that I don't have to manually create new fields in the report each month?

 

[pbaldy]

You can use code to manipulate the report as it opens, based on what the query is returning. Simpler in your case might be forcing all the months to appear:

http://allenbrowne.com/ser-67.html

 

[stevekos07]

You can use code to manipulate the report as it opens, based on what the query is returning. Simpler in your case might be forcing all the months to appear:

http://allenbrowne.com/ser-67.html

Thanks for that. I'll study it and see if I can make it work.