Re: Subreport not displaying all info

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <DuaneAtNoSpanHookomDotNet> wrote in message
news:e3peZ8rxGHA.4232@xxxxxxxxxxxxxxxxxxxxxxx
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


--
Duane Hookom
MS Access MVP

"jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
news:5_YGg.5454$e9.3939@xxxxxxxxxxxxxxxxxxxxxxxxx
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" <DuaneAtNoSpanHookomDotNet> wrote in message
news:eZGTKfrxGHA.2168@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Duane Hookom
MS Access MVP

"jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
news:HnXGg.11096$j8.8897@xxxxxxxxxxxxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: Help with query
    ... such as the definitions of the Queries you refer to, and sample records from the Tables. ... In addition to the sample records I mentioned in each of the Tables used by your Queries, I suggest that you also show an example datasheet that shows the results you'd like your Query to display, based on those sample records. ... I currently have a statement report that has a subreport of all linked to the ... the enterprise rules are payment 30 days from end of month.... ...
    (microsoft.public.access.queries)
  • Re: Subreport not displaying all info
    ... If I change the link to reflect customer number, then I only get the last ... invoice amount, payment amount, payment date. ... The subreport is in the report footer. ...
    (microsoft.public.access.reports)
  • Re: Subreport not displaying all info
    ... Remove the PaymentDate from the Link Master/Child. ... I need the subreport to have the ... same information for the same time-frame as the main report. ... If you want to show a range of payment dates in the subreport, ...
    (microsoft.public.access.reports)
  • Re: Printing Query Results
    ... Your receipt is a report with a query as the recordsource. ... In the PurchaseID field of your query for the report, ... He has just made a payment ...
    (microsoft.public.access.forms)
  • Re: Show the last record based on the last recorded date - JCW
    ... creating a separate query and base a simple one-line report on this, ... gymnast, or in the gymnast group footer or header if its grouped by gymnast. ... The query to return the last payment per ...
    (microsoft.public.access.queries)