Hi!
I manage to get these results using crosstab queries.
Date range
From: 1/1/2001 To : 31/3/2001
Class January February March ( row header) ClassA 50 48 49
ClassB 45 46 46
ClassC 49 50 50
The user will define the date range. Each time the range changes, so does the column. Question is how do I set the row header in the report dynamic so that it changes according to the date user has keyed in?
Please help!
I manage to get these results using crosstab queries.
Date range
From: 1/1/2001 To : 31/3/2001
Class January February March ( row header) ClassA 50 48 49
ClassB 45 46 46
ClassC 49 50 50
The user will define the date range. Each time the range changes, so does the column. Question is how do I set the row header in the report dynamic so that it changes according to the date user has keyed in?
Please help!