Reports, filters and crosstabs

I am using VBA to determine which query sits behind a report,
depending upon the preferred sort order. This has worked perfectly
for ordinary select queries behind reports, but it seems to be
struggling with crosstab reports. It presents a "jet engine" error.
Do you know if this is an issue, or is there a better way of doing
this?

Thanks in anticipation.

Cassie

re: Reports, filters and crosstabs

The sort order of the query is often irrelevant to the presentation on the
report.
It's better to set the sort order as a property of the report itself.
I'd suggest the report's OnOpen event as the place to do this.

HTH
- Turtle

"Cassie Pennington" <cassie.dowling@btinternet.com> wrote in message
news:473882f8.0409191032.447cabf2@posting.google.c om...[color=blue]
> I am using VBA to determine which query sits behind a report,
> depending upon the preferred sort order. This has worked perfectly
> for ordinary select queries behind reports, but it seems to be
> struggling with crosstab reports. It presents a "jet engine" error.
> Do you know if this is an issue, or is there a better way of doing
> this?
>
> Thanks in anticipation.
>
> Cassie[/color]

re: Reports, filters and crosstabs

Oh, and if you're filtering a crosstab query using parameters (e.g.
referencing controls on a form), be sure to declare those parameters
explicitly using the parameters dialog (Query - Parameters).


"Cassie Pennington" <cassie.dowling@btinternet.com> wrote in message
news:473882f8.0409191032.447cabf2@posting.google.c om...[color=blue]
> I am using VBA to determine which query sits behind a report,
> depending upon the preferred sort order. This has worked perfectly
> for ordinary select queries behind reports, but it seems to be
> struggling with crosstab reports. It presents a "jet engine" error.
> Do you know if this is an issue, or is there a better way of doing
> this?
>
> Thanks in anticipation.
>
> Cassie[/color]