query doesn't return any fields

[Goliano]

I created a database that contains 2 tables. I then created a query that simply groups the data and calculates a row total. And it works as expected. However, when I try to create a report, using the query, I get, "The wizard was unable to generate fields from the record source you chose. Perhaps you chose a query that doesn't return any fields."

What am I doing wrong?

Screencaps attached.

Thanks.

 

[namliam]

I think you cannot base a report of a Crosstab query.

 

[Rich]

Open the query before running the Report wizard

 

[Goliano]

I think you cannot base a report of a Crosstab query.

Thanks. That helped with the summary reports. But now I need to figure out how to duplicate the results of that crosstab query with a select query. Any ideas?

 

[Goliano]

Open the query before running the Report wizard

That didn't work.

 

[Goliano]

Found a solution:

In a crosstab query you must enter all the valid column headings into the Column Headings property of the crosstab query.

http://allenbrowne.com/ser-67.html

Since my column headings are the numbers corresponding to the days of the week, it was no problem. The report is running perfectly.

Thanks again for your help.

 

[pbaldy]

I think you cannot base a report of a Crosstab query.

Sorry mailman, but you can base a report on a crosstab query. I have several.

 

[namliam]

Sorry mailman, but you can base a report on a crosstab query. I have several.

You are right, i didnt think it thru fully. But you cannot base a report of a TRUE crosstab meaning without fixed columns... This is a mayor headache also for having crosstabs in forms. You have to fix the columns which basicaly is not the point for a crosstab.

 

[pbaldy]

My reports are all based on crosstab queries without fixed columns. In my case, the user chooses a date range, and the columns represent each day of the range. You get around the non-fixed columns with a little code in the report that assigns control sources and label captions dynamically.

 

[shudini]

you can check out this link http://www.blueclaw-db.com/report_dynamic_crosstab_field.htmfor an example of VBA code to dynamically populate a report based on a crosstab query.