Report from Crosstab Query

P

paula

If I've set up a report based on a crosstab query that
yields me a full range of columns, and I change the
parameters on the query, if there is an item than has a 0
value, the report will not open (it used to in an older
version!!)
"Microsoft Jet Database engine does not recognize xxx as a
valid field name or expression"
I don't want to have to change the report each time I
change the parameters.
How do I allow for a zero value from the crosstab query in
a report?
 
D

Duane Hookom

You need to set the crosstab's Column Headings property to include all
possible column names that will be used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab report - handling Null fields 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Crosstab Graph Report not showing Parameters in text box 3
Using select and crosstab queries on one report 1
Report based on filtered crosstab 5
getting a report from a crosstab query 28
Report Error for certain Crosstab Query 2
Parameters with mor than one crosstab query in a report. 8

Top