I get an error when I try to open a report which is based on a crosstab query. The error is due a missing field the crosstab after it is run on a certian set of data. The report has fixed fields which display the count of records which contain a certain value in a table. Is there some way that I can make the crosstab query display certain value feilds even if the table/query that the data comes from is not present. Also I have tried IIF statements in the report to ignore the missing feild and display 0 but this did not work.
The report works fine if the feild is present in the crosstab query.