Student A subject 1

Student A subject 2

 

Student B subject 1

Student B subject 2

 

Or are you trying to do something different? 

 

Was a reason given as to why can't you use a subreport?

 

-Dell

Assuming you have the following type of relationships between your tables:

 

Subject <--> Student_Subject <--> Student

 

Another way to solve it would be to link from Student to a second copy of the Student_Subject table and from that table to a second copy of the Subject table.  When you add a table to the report that is already in the report, Crystal will let you know that it's already there and ask if you want to Alias it.  When you click on Yes, it will add a second copy of the table with "_1" at the end of the table name so that you can reference it separately from the original table.

 

-Dell