Project Record (Parent) Fields  1 to 1 with Project

   Sub Records 1   0 to many with Project

   Sub Records 2   0 to many with Project

   Sub Records 3   0 to many with Project

   Sub Records 4   0 to many with Project

   Sub Records 5   0 to many with Project

   Sub Records 6   0 to many with Project  

 

I've tried the normal approach which for me is to create a sub report for each of the sub sections. The performance is so bad that it is not close to usable.

 

I've tried all kinds of groupings with suppressions, etc with everything on the parent report but the results are wildly unpredicatable. All of the sub sections appear to react to each other in ways that I can't control with limiting formulas etc.

 

Has anyone successfully faced this problem before?

 

Thanks, Moosehead

 

For instance, since I have 6 sub reports how do you create one data set that doesn't have those reports creating a huge number of rows?