Report with subreport sorting and grouping

[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

 

[George Nicholson]

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,

 

[eb1mom]

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.