Parameter query okay; parameterized report--different data

L

Londa Sue

Hi,

I've a report that is built on a query. Since there are numerous records
that could end up in a report, I put a parameter on the query to ensure that
I only get the report for a specific record, and that the page numbering is
correct (whole report could have 6 pages, but it has reports for three
different records. Record 2's page numbering would be "Page 3 of 6" and
"Page 4 of 6" instead of "Page 1 of 2", etc.

When I run the report based on the parameter (AuditID), some of the data is
for that specific record, while other data is from the first record. Now,
when the report is run without the parameter, all the data for each of the
records is correct. The problem with generating the report this way is
searching, page numbering, etc.

Any ideas on what is happening?

Thanks,

Londa Sue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top