I have a problem with a report based on a crosstab query
The crosstab query shows the number of players per team by date as the sample below shows.
Date Total of Last 1 2 3 4 5 …..
2006/05/11 173 11 8 8 9 11
2006/05/18 149 8 7 10 8 11
2006/05/25 181 13 7 11 10 11
2006/06/01 160 11 8 9 10 8
2006/06/08 162 7 11 8 11 10
…
I was asked if I could provide totals for each team over all the dates. I couldn't see a way to add totals within the crosstab query so I created a report based on the crosstab query.
The report works with out a problem until I try to group by year. When grouping by year the order of the dates comes out incorrectly, if I group by month or day the sort order works fine. I typed the following sample to show what I am seeing. I have also attached a screen print of the report output.
Date Team 1 Team 2 Team 3 ......
2006/07/13 10 6 10
2006/05/18 8
2006/05/25 13
2006/06/01
2006/06/08
2006/06/22
2006/05/01
.....
The totals in the group footer are correctbut as yiou see above the dates are not in the correct order.
If anybody has an idea why the sort order gets messed up I would appreciate the help.
Thanks Kevin ….
The crosstab query shows the number of players per team by date as the sample below shows.
Date Total of Last 1 2 3 4 5 …..
2006/05/11 173 11 8 8 9 11
2006/05/18 149 8 7 10 8 11
2006/05/25 181 13 7 11 10 11
2006/06/01 160 11 8 9 10 8
2006/06/08 162 7 11 8 11 10
…
I was asked if I could provide totals for each team over all the dates. I couldn't see a way to add totals within the crosstab query so I created a report based on the crosstab query.
The report works with out a problem until I try to group by year. When grouping by year the order of the dates comes out incorrectly, if I group by month or day the sort order works fine. I typed the following sample to show what I am seeing. I have also attached a screen print of the report output.
Date Team 1 Team 2 Team 3 ......
2006/07/13 10 6 10
2006/05/18 8
2006/05/25 13
2006/06/01
2006/06/08
2006/06/22
2006/05/01
.....
The totals in the group footer are correctbut as yiou see above the dates are not in the correct order.
If anybody has an idea why the sort order gets messed up I would appreciate the help.
Thanks Kevin ….