Crosstab Report - Variable number of control sources

  • Thread starter Thread starter M S
  • Start date Start date
M

M S

I have a report based on a crosstab query. Each column is "1" through "10"
calls. I made my report with fields for each one, 1 through 10. However,
sometimes there are only 5 or 7 calls when I need to run the report. But it
errors out and says the control source for the blank values is invalid. For
instance, if there are 9 calls rather than 10, my report won't open because
"10" isn't a valid control source.

Any ideas?
 
You can add all possible column heading values to the Column Headings
property of the crosstab query.
 
Back
Top