Date parameter in report

[ekta]

Hi All:

I have created a report that has 3 subreports.
I wanna do 2 things:
1. One of the subreport has a date field. I want that the user should be able to enter the a date range and the subreport would display only the records within that date range.
In the query on which my subreport is based I entered the criteria:

between [Enter start date] and [Enter end date]
When I run the report it asks me to enter start date and then end date. But after entering the end date it again asks me to enter the start date and so on. I dont know why its doing that.

2. The user wanna filter the records in another subreport by the field Open/Close, which is a check box. I dont know how to do that.

So in one line..I want to filter records on my report by date field which is on a subreport and by Open/Close which is on other subreport. How should I do this????This is driving me crazy.

Thanx in advance
Ekta

 

[llkhoutx]

Put fields, with the Criteria for the resordsource for each of your subreports, on the form which opens the reports. Adjust the recordsource for each subreport accordingly; that is, with criteria from the form.

 

[chewy]

did you ever get this to work I cant figure this out myself. Especially sending the checkbox value to a query