I am trying to create a "Master" report of sorts. It will contain many SUb-reports that are on demand only.  The system we use is terrible for grouping and sorting reports. So I am trying to group all reports on a main report to clean up the system and create less confusion.

 

EX: Appointments_Master_Report would include all reports that have anything to do with Appointments.

 

Question/ Problem:

   I have sub-reports that require parameters. When I run the Master Report is is asking for the parameters for each sub report....some of which may be a date range, or a client name...etc. Is there anything I can do so that the parameters prompt will only run when the specific sub-report is opened. Other than asking for a standard date range / client etc ...then passing it to all of the sub reports reguardless.

 

EX:

        Appointment_Master_Report

 

Client next appt report: needs date range and client name

canceled appt report: needs date range only

 

Thanks.