Grouping Data from SubReports

[IreneJ]

I have four subreports on one main report, each subreport
runs off a query with parameters for BeginningDate and
Ending Date and CrewID selection. The subreports are
unlinked on the main report.

If I run only one date i.e. Aug 10 for a crew I get the
data for that date I want from each subreport in the
order of the subreports on the main form. I have totals
in the Date Footer for each subreport and grand totals in
the Report Footer.

If I run a group of dates i.e. Aug 10 to Aug 13 it
doesn't put the information in that same order. It
changes it and puts all four dates for the first
subreport all together, then all info for the second
report for all four dates, etc. That then causes the
totals not work properly also but I think if I can figure
out the proper grouping of the data then the totals might
straighten out but at this point I'm unsure.

May I ask for some further help with this.

Regards,
IEJ

 

[Fons Ponsioen]

I think what you want is the that each subreport shows
data for on date and than cycles to the neat date where
all subreports againsh run. Is this coorect?
Fons

 

[Duane Hookom]

You have kinda described what is happening but not what you want to happen.
I think you might want to add a record sourceto your main report based on a
date field. Then set the Link Master/Child properties to limit each
subreport to the date in the main report.