Report with subreport sorting and grouping

  • Thread starter Thread starter Eb1mom
  • Start date Start date
E

Eb1mom

I have been working on this for a while and even with help
from here seem to be getting nowhere.Two tables, one has
production information, the other delay information. Both
tables have a record date field. I am trying to create a
report that would show all production records for a given
date and then all delay records for same date. Then
production records for next date followed by delay records
for that date. I created a report for production data and
made a subreport for delay data, master child link is the
date field. I am now getting one production record and all
delay records then another production record and again all
delay records. When I try for all records for a month I get
thousands not just the few hundred there should be. I know
I am totally messed up here just not sure what to try next.
I have a report that shows all production records sorted by
date and a report that shows all delay records sorted by
date, both work fine. Any suggestions on reading material
to help me get this mess sorted out? Thanks
 
Your subreport is in the Detail section?

Try this: assuming your report is sorted/grouped by Date, add a Footer to
the Date field. Then put your Delay subreport into the Footer and it should
only appear once-per-date (after all the Production Detail) rather than
every time the date occurs in the Production Detail which is what you have
now.

HTH,
 
Yes my subreport was in the detail section. Adding footer
was a GREAT improvement to the report. Thank-you for taking
the time to reply to my post. I appreciate your help.
 
Back
Top