CrossTab
Posted: Thu May 31, 2012 5:19 am
Hi Everyone,
I enter a crosstab into my report show days of the week and the number of library issues which works fine, I then adda second crosstab to display the number of returns by the days of the week and get an error 3022.
If I make the second crosstab exactly the same as the first the crosstab the report works, it's only when the two crosstabs are different the report errors. The only thing I change when it doesn't work is the field the count is done on instead of issuedate its done on returndate
Is it possible to have two crosstabs looking at two different things I.E. number of issue by day of the week and then another with number of returns by day of the week?
I enter a crosstab into my report show days of the week and the number of library issues which works fine, I then adda second crosstab to display the number of returns by the days of the week and get an error 3022.
If I make the second crosstab exactly the same as the first the crosstab the report works, it's only when the two crosstabs are different the report errors. The only thing I change when it doesn't work is the field the count is done on instead of issuedate its done on returndate
Is it possible to have two crosstabs looking at two different things I.E. number of issue by day of the week and then another with number of returns by day of the week?