How do I print a report base on it's subreport's sorting.

G

Guest

I have a one to many report based on the FAMILY table with a subreport based
on the STUDENT table. The STUDENT subreport is sorted by grade (youngest
grade first). I need to print labels grouped by the youngest child's GRADE
then TEACHER.

How do I keep the FAMILY/STUDENT records together AND group the main records
based on the subreport sorting (i.e. STUDENT.GRADE then STUDENT.TEACHER then
FAMILY.FAMILY#)?
 
D

Duane Hookom

You need to figure out a way to get the sorting fields/values into the
record source of the main report.
 
G

Guest

Thanks for your response. I looked into creating a query based on the FAMILY
table and the STUDENT table. Then for GRADE, selected MIN and it limited the
records.

I then based the report on the query and was able to use these query fields
to sort the report.

THANKS for making me think differently!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a one to many report - One record with subreport 3
multiple page print problem based on number of items in subreport 8
how can i propogate a subreport filter up to the main report? 7
Trouble with creating a Room Parent Report 1
Using Subreports to create a Main Report 7
Print Report from Form 11
sorting in a subreport 1
Sorting by field in a report 2

Top