Adding Crosstab Query Reports to Subreports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Public Schools - 25 Mar 2008 15:43 GMT

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?

Signature

Helping the kids

Reply to this Message

Duane Hookom - 25 Mar 2008 22:22 GMT

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?

Signature

Duane Hookom
Microsoft Access MVP

> Help! (using Access 2003)
>
[quoted text clipped - 6 lines]
> an error. The crosstab reports are perfect, I just can't get them on 1
> report. Is this possible?

Reply to this Message

Public Schools - 28 Mar 2008 15:28 GMT

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!

Signature

Helping the kids

> This should work if the crosstabs have their Column Headings property set.
>
[quoted text clipped - 11 lines]
> > an error. The crosstab reports are perfect, I just can't get them on 1
> > report. Is this possible?

Reply to this Message

Duane Hookom - 28 Mar 2008 16:29 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> 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
[quoted text clipped - 17 lines]
> > > an error. The crosstab reports are perfect, I just can't get them on 1
> > > report. Is this possible?

Reply to this Message

Public Schools - 28 Mar 2008 21:18 GMT

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!

Signature

Helping the kids

> 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
[quoted text clipped - 23 lines]
> > > > an error. The crosstab reports are perfect, I just can't get them on 1
> > > > report. Is this possible?

Reply to this Message