Hi All,

I have a question relating to an issue I am having that is definitely related to grouping.  Sadly, I do not know how to accomplish what I need to do as adding groups to my report sadly seems to be causing the issue.

I am working basically from three tables - Contract, ContractParticipant, and ContractComment.  Contract has a LEFT OUTER JOIN relationship to the other two tables based on the Contract#.  ContractComment and ContractParticipant have no relation and need to display their data separately which is why I have been trying to display their results in separate groups.  Both tables can have multiple values/entries saved to the table for every Contract.

What I am trying to achieve is to display the reports in this way...

1. CONTRACT and all relevant fields
2. All data from CONTRACTPARTICIPANT
3. All data from CONTRACTCOMMENT

So the data might look something like this...

"Contract:
15003

Participants:
150
200
300

Comments:
Notes 1...
Notes 2...
Notes 3..."

So my grouping looks like this:
Group Header 1 - Contract fields
Group Header 2 - Participant fields
Group Header 3 - Comment fields

They do have a specific sort order but I basically get an output where I receive one participant followed by one comment followed by another participant followed by another comment, etc.  How am I supposed to group and sort different tables so that one table displays all of its data... followed by another group that displayed all of the data from that table.  Again, these two tables have no relationship and I just need all of the data to display separately.  How can I achieve this?

Thank you, everyone.

I have never worked much with sub-reports and wouldn't expect anyone to teach me everything here... do you know of any particular guide online that might be able to help me build a subreport?  I was reading around and it did sound like this might be the way I need to do this...

Thank you!