Subreport not displaying all info

[jwr]

I have created a main report and a subreport.

The main report has a beginning and ending date parameter.

The subreport is based upon a query that is based upon a query that is based
upon a query that was used for the main report.

All queries run as they should when opened individually. The main report
works as it should.

The main report and the subreport are linked by PaymentDate. When I run
this main/subreport:
a. I only get 2 items to display in the subreport -- dated 8/17/06.
The main report displays 10 pages of information. This is true regardless
of the date range selected when the report opens. I can use the entire year
or just a month range and only get items with payment date of 8-17-06. I
have looked at all queries and none of them have a parameter of any sort.
b. The headers do not display for the subreport.

I can change the link to a different field and the results are still the
same. I have no filters on.

Any suggestions would be appreciated.

Thanks

 

[Duane Hookom]

What happens if you remove the Link properties? I can't think of too many
situations where I would filter the main report on a date range and then
link master/child on a date field.

What report section is the subreport located in? Is it in a date header or
footer?

Page sections will never display in subreports. You can use report or group
headers or footers.

 

[jwr]

If I remove the Link properties, I get too much information in the
subreport. I get dates for all payments received from the beginning of my
database.
If I change the link to reflect customer number, then I only get the last
customer listed on the main form.

The main form lists my customers orders by customer number, invoice #, total
invoice amount, payment amount, payment date.
The subform lists the customer number, invoice #, payment date, Essett
amount, Essett number, and Essett date. Therefore, all my information
needs to be reported for the same time frame.

The subreport is in the report footer. It is not in a date header or
footer.

Thanks for your prompt response.

 

[Duane Hookom]

If the subreport is in the report footer and is linked on the Paymentdate
field, the subreport will only contain records from the last payment date
value in your detail section. No other payments will be displayed.

If you want to show a range of payment dates in the subreport, you will need
to set a criteria in the subreport's record source like:

WHERE PaymentDate Between Forms!frmDates!txtStartDate And
Forms!frmDates!txtEndDate

 

[jwr]

I originally set the date range in the criteria field of the payment date on
my query. When I did this, I kept getting a pop-up form that continuously
asked for the beginning and ending date, and once the form cleared, only the
last information was displayed.

What is the best way to handle this? I need the subreport to have the same
information for the same time-frame as the main report.

Thanks

 

[Duane Hookom]

Do as I suggested. Remove the PaymentDate from the Link Master/Child. Then
create a form for the user to enter the dates. Use references to the form
controls in the criteria of the subreport's record source as suggested. Then
open the form and enter dates. Run your report.

 

[jwr]

Thank you -- I was putting a date range on both main and subform and
therefore, kept getting popup box for date.