CrossTab Report with parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Scott said:
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.
Click to expand...

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.
 
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.
 
Scott said:
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.
Click to expand...

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