Re: Subreport not displaying all info

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: crystal report subreport - leaves space for main rpt footer
    ... I have a crystal report that I have a subreport in the group header. ... link the main report to the subreport by a customer id. ... Use this group footer for your totals. ...
    (microsoft.public.vb.crystal)
  • Re: Counting and totaling from a subreport
    ... text box that displays the subreport total. ... report grand total calculation. ... subreport's footer and that the total does not appear on the ... box names and their control source. ...
    (microsoft.public.access.reports)
  • Re: Repost-Still Suffering with Subreports
    ... the date footer from the subreport and use only the subreport report footer. ... Do I dare ask how you are creating a report based on a crosstab? ... >>>>totals in the subreport in the report footer. ...
    (microsoft.public.access.reports)
  • Re: Counting and totaling from a subreport
    ... running sum I manage to get it to work. ... text box that displays the subreport total. ... report grand total calculation. ... subreport's footer and that the total does not appear on the ...
    (microsoft.public.access.reports)
  • Re: Subreport not displaying all info
    ... same information for the same time-frame as the main report. ... the subreport will only contain records from the last ... If you want to show a range of payment dates in the subreport, ... If I change the link to reflect customer number, ...
    (microsoft.public.access.reports)