Sub report linking

[edwardcga]

I have a report with a Sub Report linked by an ID. In main report, OFFER_ID linked to Sub Report of the same field. In main report the parameter is a range (e.g FROM ID 1001 TO 1005) but the sub report only returns record of the first ID ie 1001. How can I pass the main report selection to the sub report to select all records with the parameter range inputed in the main report.



Thanks

RR

[June7]

The subreport only shows records that are related to the current record of the main report because of the Master/Child links. That's how the report is designed. If you don't want this dependency then don't set the Master/Child links and instead apply the same filter criteria to the subreport.

[edwardcga]

Thanks for the advice. I took out the link but I have to type in the parameter 3 times to run the report. Is there a way that I can key in the parameter
(Between [Enter Start Date] And [Enter end date]). How can I store the parameter and pass it to the sub reports. Currently, the main report and sub report are based on a query for each. Your advice will be much appreciated.

RR

[June7]

Enter the criteria into unbound controls on a form.

The query parameters reference the controls.

http://datapigtechnologies.com/flash...mtoreport.html

[edwardcga]

Enter the criteria into unbound controls on a form.

The query parameters reference the controls.

http://datapigtechnologies.com/flash...mtoreport.html

Thanks for the advice. I am a novice and in what way I can accomplish this. Create a from, with UNBOUND parameter STARTDATE, ENDDATE. What is the next step and how do I start the report. Please provide steps in achieving this.

Thanks

RR

[June7]

What about the tutorial do you not understand?

Open the report directly from the navigation pane or with code behind a button. Do you use macros or VBA?

[edwardcga]

What about the tutorial do you not understand?

Open the report directly from the navigation pane or with code behind a button. Do you use macros or VBA?

Thanks. This is a good tutorial. Will follow the example and try. First time using VBA.

RR