Creating Subreports

  • Thread starter Thread starter Troy Scott
  • Start date Start date
T

Troy Scott

I am trying to insert a subreport in a report. The report is based off on a
query that prompts the user for a beginning and ending date. The subreport
is on a query that has a date field, but it does not contain any criteria.

The problem I have is the subreport shows up on each page with the same
info. I want the subreport to show up at the end of the main report, which
is usually on the same page near the bottom. HELP!

Many thanks,

Troy
 
Sounds like the subreport should be contained in the REPORT FOOTER section
of the main report.
 
That worked Duane, however when I enter the beginning and ending criteria to
run the report I only get the correct date on the main form. The subreport
shows all dates instead of the same criteria. How do I get the subreport to
query on the same date? I tried entering the criteria on the subreport
query, but when I run it I'm in a loop it seems of it asking me beginning
and ending date.

Troy
 
Don't use parameter prompts in queries. Create a form with text boxes or
other controls for the beginning and ending dates. Assume a form "frmDates"
with text boxes "txtStartDate" and "txtEndDate".
You can then set the criteria in the report's record source query to:
Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate
 
ok, I think I understand that, but how will I link the
form to the report? In other words, how will I "start" it
if it's in a form?

Troy
 
Back
Top