Crystal Reports .net DataTable RElations/ Report Organization

[LikePork]

Hey, I'm new to Crystal Reports and having difficulties getting help with what I'm trying to do, but I bought Brian Bischoffs book and am working on it. I'm using the Crystal Reports packaged with .net(is this the right forum uhoh) and I'm creating a report using an ADO.net dataset that I filled manually from a few different sources.

My dataset has several tables, so I'm using groups in my Crystal Report to represent the child relations in the table , so there is a "report"(not a new report object, just a different heading in the same viewer) for every row in my first Table(I'll refer to it as ErrorReports), then several pages for each row in it's child Table(referred to as Report).

ErrorReports - Reports - Errors
|_ other Errors

This works fine but after this I run into problems as the Report Table has more than one child relation (see my attempt at a figure above), so what I want to do is have all the data from one child Table written out then on a new page all the data from the next child Table.

I can't make a group for each because the groups must keep thier structure such that any new group is contained in the by the last newest group(I'm not really sure how to explain this, the "smallest", "most specific") so that no group can contain 2 unrelated groups, they must contain one group that may contain a group itself. So I hope someone understands what I mean there.

Anyway I have considered using a subreport but I'm not sure how to refernce the specific Report row's children rows so that the subreport is in the right place.

Also I've tried to split the groups into sections but this seems to really do nothing, when it fill the data it just puts the sections together as if they were one, and since the 2 child Tables contain different amounts of rows it really can't work this way. If I could split the group into sections and have a formula slecting which to show when I could maybe do it but I'm pretty sure this will not wrok either.


Any other suggestions would be greatly appreciated, I can never find any info about reports using "complicated" Relations like mine

Please respond if you'd like clarifications, I wouldn't be surprised, or if I'm in the wrong place here. Any help would be useful thanks a lot.

 

[LikePork]

I figured out a way to do it, apparently with muliple child relations I am forced to use sub reports after all. When I create the subReport there is a linking option that I can use to access the proper child Rows. There is an explanation on how to suppress empty sub reports in Bischoff's book, but it ain't pretty. I've finally gotten it work though, (hours spent with CR fell like days), but I'll keep cehcking this thread if anyone would like to add some explanations or comment further.