CrossTab Report with parameters

[Guest]

I would like a form to print a report based upon a crosstab query. The
crosstab query has two parameters: the starting and ending date. I couldn't
make a report based upon my crosstab query because of the paramters. I could
make a report based upon the same crosstab query if I removed the parameters.
But, this would not allow me to input the starting and ending dates when
printing the report. What am I doing wrong?
Thank you.

 

[Rick Brandt]

I would like a form to print a report based upon a crosstab query. The
crosstab query has two parameters: the starting and ending date. I
couldn't make a report based upon my crosstab query because of the
paramters. I could make a report based upon the same crosstab query
if I removed the parameters. But, this would not allow me to input
the starting and ending dates when printing the report. What am I
doing wrong?
Thank you.

You can use parameters in a crosstab query, but you have to enter them
explicitly in the parameters dialog of the query while in design view and
identify the datatype.

 

[Guest]

I tried that. Then I tried to use the report wizard to create a report.
The AutoReport Tabluar gave me the error message: The Wizard was unable to
generate fields from the record source you chose. Perhaps you chose a query
that doesn't return any fields.
The Report Wizard had no available fields listed.

 

[Rick Brandt]

I tried that. Then I tried to use the report wizard to create a
report.
The AutoReport Tabluar gave me the error message: The Wizard was
unable to generate fields from the record source you chose. Perhaps
you chose a query that doesn't return any fields.
The Report Wizard had no available fields listed.

The wizards have lots of limitations. Just build the report without it.