Larry,
Thanks for the response. The reason this is a problem is because the report
we want, if we go vertical with it, has 5 grouping levels so we can get a
clean format and because all the grouping levels have a one-to-many
relationship back to the previous level. The preferred way to look at the
data is not vertical of course, that would be to easy, but to look at each
group Horizontally, left to right. It is simple to drop in 5 subreports and
to link the key data back to the main report. That of course works fine and
I have that working. But because each sub-report is linked to the main, then
it is difficult to get the data in each sub report to allign
to the previous sub-report (the one to it's left) and maintain the one to
many relationship that each sub has to the previous sub. By linking all
sub's to the main we easily maintain the one-to-many that each has with the
main report but do not have a perfect alignment form one sub to the next.
The report will show 5 company business units. Each unit sets a goal that
links to the previous units goal (it's parent). And each unit creates sub
goal (one-to-many)
piece. So ideally we would want the report to show the corp goal, left most
sub report, and then each sub report will print there goals and they are not
linked to the
corp but they are linked to the previous sub.
Also, each sub report has one grouping level, so droping each sub into
another sub creates a realy ugly report as each sub report goes through its
own grouping. Lots of white space.
Hope this helps
