Report with Subreports ----M-----

[Mark909]

Im creating a report containing infomation from multiple queries in the form
of subreports.

I have set up the queries so the enter parameter box pops up and you enter
the name a contractor or project id.

However due to have multiple parameters the enter parameter box needs to be
filled in 4 times before the report is produced.

I was wondering if anyone has any ideas how i might cut down on the amount
of time the enter parameter box appears?

 

[Clifford Bass]

Hi Mark,

A couple of possibilities.

1) Include the parameter as an actual field in the report's main query.
Just place something like this on the Field line in the query designer:

ContractorProjectIDParameter: [Enter contractor or project ID:]

Get rid of the parameter and any associated conditions from the
subreports' queries. Then use that field as one of the linking fields in
your subreports.

Or, use a parameter form where the person would enter the value and
then click a button to open the form. Then in your queries, remove the
parameter references and use the field on the form instead:

select .... where SomeField =
Forms![frmContractorProjectParameter]![txtContractorProjectID]

Hope that helps,

Clifford Bass

 

[Mark909]

Thanks Clifford,

That helps but it only selects information from either contractor or project
id.

I need to sort the data so that it first queries out all the data related to
project id and then queries out the data relating to a specific contractor.

So it would be select project id and then select contractor rather than
select contractor or project id

Thanks

Hi Mark,

A couple of possibilities.

1) Include the parameter as an actual field in the report's main query.
Just place something like this on the Field line in the query designer:

ContractorProjectIDParameter: [Enter contractor or project ID:]

Get rid of the parameter and any associated conditions from the
subreports' queries. Then use that field as one of the linking fields in
your subreports.

Or, use a parameter form where the person would enter the value and
then click a button to open the form. Then in your queries, remove the
parameter references and use the field on the form instead:

select .... where SomeField =
Forms![frmContractorProjectParameter]![txtContractorProjectID]

Hope that helps,

Clifford Bass

Im creating a report containing infomation from multiple queries in the form
of subreports.

I have set up the queries so the enter parameter box pops up and you enter
the name a contractor or project id.

However due to have multiple parameters the enter parameter box needs to be
filled in 4 times before the report is produced.

I was wondering if anyone has any ideas how i might cut down on the amount
of time the enter parameter box appears?

 

[Clifford Bass]

Hi Mark,

From your initial description, it was not apparent that you had
multiple parameters for each query. Be that as it may, I would think you
could just extend the idea, adding items as needed to the main query and
linking on those items also. If that does not help, post some specifics such
as the relevant parts of your reports' record source queries. And how they
are related.

Clifford Bass