passing parameters to a report.

[gonzosez]

I have an application that gathers 3 parameters from a query.
Now I need to pass those parameters to the query in a report.
How do I do this?

Thanks

 

[Guest]

Just create a report based on the query, when you run the report you'll be
prompted to enter the parameters.
Alternatively, you can create a form where the user enters the parameters,
maybe via combo-box, and then have a query link to the input fields in the
form. Your report would be based on that query and would automatically take
the parameters as entered into the form.

 

[gonzosez]

I need to be seemless.
The parameters are provided by the first query.

 

[Guest]

So what's preventing you from using that query as a base for your report?
Are you talking 2 queries here? One that gathers parameters, and another you
base your report on?
You can have the second query look up the fields in he the first query that
contain the parameters.

 

[gonzosez]

Here is the scenario
it is an application that produces copies of checks from a database for an
electronic document system.
The checks are run in batches.
The first query collects the batch id, check no and control number.

For each record in query1
Open report based on the parameters supplied by query1
Print report
Close report
Loop

The idea is to run through the batch of checks with out user intervention.

 

[Guest]

Hm, if I understand your situation correctly, you could make a form instead
of a report, and then print everything. That'll print all the records that
match your parameters.

It this isn't really what you are looking for, then I can't help you, sorry.

 

[gonzosez]

Thanks.
I think that the form useing a form may be the way to go.
Thanks again for your help.

 

[John Vinson]

Here is the scenario
it is an application that produces copies of checks from a database for an
electronic document system.
The checks are run in batches.
The first query collects the batch id, check no and control number.

For each record in query1
Open report based on the parameters supplied by query1
Print report
Close report
Loop

No looping is needed.

You're not printing multiple REPORTS - different layouts on the page -
are you? Surely you're printing one report with multiple pages! And
you don't need two queries; you need one, based on a Join of your
query1 and query2.

John W. Vinson[MVP]