Form Driven Report Problem

[DBnub11]

I have a from that drives a number of queries before displaying a report with crosstab query data. I got that working

The problem is I was testing this out using the largest data set ie the report is holding the worse case senario with a lot of data. When I select criteria which is only a subset some of the column headings are no longer needed and do not appear in the report.

As a result I get an error. Any way I can have it display what the query does have without populating the fields it does not see

My cross tab has months along the top. For certain selections not all the months are not represented in the qurey results.

My report on the other hand has all the months. So when its all there its fine when something is missing it breaks

Need Help

 

[vbaInet]

A crosstab query with dynamic column headings cannot be used in a report. Well, you can but as you've noticed the column headings are not in the list of available fields.

The crosstab query must have static column headings for it to be visible in the list. This will provide some insight:

http://allenbrowne.com/ser-67.html

 

[DBnub11]

so basically use the info in the link to pull zeros for stuff it does not find?

Edit

OK this may need to be put in a different place

I have a query that generates data for the cross tab. Do I need to force it to have data for all the columns so everone is represented.

Is there a way to have a query pull something if it doesn't exsit like a dummy message that nothing was found. I think that would solve me issue.

Thanks in advance

 

[vbaInet]

Looks like we're still going back to my point of creating static Column Headers. As long as you don't make the Headers static, the column headers cannot be used in the report.

In the link, look at the heading "Specify Column Headings".