Adding Crosstab Query Reports to Subreports

[Public Schools]

Help! (using Access 2003)

I have created 3 crosstab query reports (Division pass rates by course,
school pass rates by course, and school pass rates by course and grade - with
percentages) and would like to use reports on one page by school. However,
when I begin making my subreports I receive an error regarding the use of my
crosstab query reports in subreports. I can put the division report on page
because it is unbound but can not get the schools to show up on page without
an error. The crosstab reports are perfect, I just can't get them on 1
report. Is this possible?

 

[Duane Hookom]

This should work if the crosstabs have their Column Headings property set.

What method are you using to create your crosstab report? Are the columns a
static list of values?

 

[Public Schools]

Mr. Hookom, thank you for your response. I am creating crosstab reports with
wizard using the crosstab query I created. I did change the look of the
report to create the look requested by client. Perhaps I deleted something
in the process. I'll keep trying. I'm glad to know it CAN be accomplished.
I've been working on this for 3 weeks!

 

[Duane Hookom]

Crosstab columns are quite often dynamic. This means they might change. This
can cause issues with reports that might expect a column/field for "July" and
the crosstab doesn't generate one. There are several solution to get around
this issue. The most common is to enter all potential column headings into
the Column Headings property of the crosstab query.

 

[Public Schools]

You are great! It worked!! Now I have a few minor problems to work out this
weekend just as white space between the last two reports and for some reason
my third subreport is repeating same school on every page. I may be back on
Monday.

THANK YOU SOOOOO MUCH!