Sub-reports causes multiple parameter prompts

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five reports
(two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add the
5 reports to one, as 5 sub-reports, the Parameter prompts the user 5 times.
Is there any way around this so the user is only prompted once?

Thanks beforehand,

Jacques
 
Create an unbound form, with text boxes where the user can enter the values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]
 
Sorry for not responding sooner.

There is only one query that feeds all 5 reports. Each report uses a
different piece of information.
and
One of the parameter prompts is in a query that the final query pulls from
(both prompts aren't in the same query).


Allen Browne said:
Create an unbound form, with text boxes where the user can enter the
values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jacques Latoison said:
I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five
reports (two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add
the 5 reports to one, as 5 sub-reports, the Parameter prompts the user 5
times. Is there any way around this so the user is only prompted once?
Click to expand...
Click to expand...
 
So, if you want to only prompt the user ONCE for all the reports, create a
form, and refer to it in the Criteria row of the query.

Guess I'm missing the problem here.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jacques Latoison said:
Sorry for not responding sooner.

There is only one query that feeds all 5 reports. Each report uses a
different piece of information.
and
One of the parameter prompts is in a query that the final query pulls from
(both prompts aren't in the same query).


Allen Browne said:
Create an unbound form, with text boxes where the user can enter the
values.

In the queries that feed your subreports, refer to those controls on the
form, e.g.:
[Forms].[Form1].[Text1]


Jacques Latoison said:
I have a set of 5 Report objects that all pull from the same Query. The
Query possesses 12 fields where 10 of them are split among the five
reports (two fields per report).
I have a parameter in the Query to prompt the user.

I would like to make one Report object that contains all 5. When I add
the 5 reports to one, as 5 sub-reports, the Parameter prompts the user 5
times. Is there any way around this so the user is only prompted once?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top