Dynamic row header in report using Crosstab query.

[ezuria]

I have a problem dealing with Crosstab queries as the source to my report. I have a crosstab queries that changes the number of columns each time when user enters the date range.
Example:
(1st user)
From: 1/1/2001 To : 31/3/2001
Class January February March
ClassA 50 48 49
ClassB 45 46 46
ClassC 49 50 50

(2nd user)
From: 11/3/2001 To : 31/3/2001
Class March
ClassA 49
ClassB 46
ClassC 50

The queries works fine.The results are correct.
But,how do I automatically generate a report with the exact number of columns, with the right month name as the row header each time the user enters the date range?
Please help!
Thanks.

 

[tlbroadbent]

Access versions 95, 97 and 2000 provide a sample database named solutions.mdb (or in 2000 solutions9.mdb). One of the samples is "Create a Crosstab Report with Dynamic Column Headings." Load the samples database from the installation CD.

The Access 2000 samples database can be downloaded from

http://msdn.microsoft.com/library/en-us/bapp2000/html/bapp2000.exe.

Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln