Report from a Crosstab w/Parameters

I'm working on a crosstab query that has parameters. I read an article that
said to add the parameters to the Query/Parameters as well as in the criteria
row. The query runs fine now but I have a problem with the report that is
based on that query.

When I run the report, it asks me to fill in the parameters over and over
again, but doesn't get to the report (at least I wasn't patient enough to try
it for more than 3 times).

When I get to Design View of the report, all of the fields listed in the
Detail section show up as if they are not fields that are in the data source.

Any ideas as to what I can do to fix this problem? I appreciate any help
you (or anyone replying to this) can give!

Thanks.

First check the spelling of the parameters and make sure you have not made an
error there.

Next make sure your report has the correct source.

Last be aware that you need to be sure that the query always returns the same
columns of data. If you change the parameters the number of columns may change.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

sg wrote:
I'm working on a crosstab query that has parameters. I read an article that
said to add the parameters to the Query/Parameters as well as in the criteria
row. The query runs fine now but I have a problem with the report that is
based on that query.

When I run the report, it asks me to fill in the parameters over and over
again, but doesn't get to the report (at least I wasn't patient enough to try
it for more than 3 times).

When I get to Design View of the report, all of the fields listed in the
Detail section show up as if they are not fields that are in the data source.

Any ideas as to what I can do to fix this problem? I appreciate any help
you (or anyone replying to this) can give!

Thanks.