Re: Subreport not displaying all info

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


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:O$oW$bsxGHA.4336@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Duane Hookom
MS Access MVP

"jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
news:uGZGg.5460$e9.3799@xxxxxxxxxxxxxxxxxxxxxxxxx
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: Report based on calculations of 2 records
    ... Is there no other way to generate the report from my existing records? ... When a customer makes a payment, ... PayFrom and PayTo on reports. ...
    (microsoft.public.access.reports)
  • Re: Ledger for Individual Customers
    ... The form will have 2 unbound text boxes, and a command button that opens the report. ... The report that lists any orders and any payments in that period, based only on the OrderDate and PaymentDate, regardless of whether the payment is for an order in that period or not. ... Life time transcations of a particular customer (right from day one the ... > Ship Address ...
    (microsoft.public.access.reports)
  • 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: Subreport not displaying all info
    ... If the subreport is in the report footer and is linked on the Paymentdate ... If you want to show a range of payment dates in the subreport, ...
    (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)
Quantcast