I have created a number of simple crosstab queries. Each has one set of column headings and one set of row heading. For example quantity of different case types handled by worker in one month.
When I try to create a report on any of these queries, I am unable to.
If I use the report wizard and select the crosstab query, no fields are listed and the wizard wont let me continue without fields. If I try selecting the query in the database window and clicking autoreport. I get the message that it is not possible to create a report maybe because there are no records (but there are!).
Am I missing something? because there are plenty of posts from people that have created crosstab reports.
Note all crosstab queries are parameter queries!
Sametch
When I try to create a report on any of these queries, I am unable to.
If I use the report wizard and select the crosstab query, no fields are listed and the wizard wont let me continue without fields. If I try selecting the query in the database window and clicking autoreport. I get the message that it is not possible to create a report maybe because there are no records (but there are!).
Am I missing something? because there are plenty of posts from people that have created crosstab reports.
Note all crosstab queries are parameter queries!
Sametch
