Linking a subreport to another subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master report and I want to add 4 subreports to this master report.

I want to link the first report to the master and I can do that fine. I
want to link the second report to the 1st sub report but I do not want to
inbed the 2nd subreport into the 1st subreport. Is it possible to link a sub
report to another sub? All I can see is linking to the master.
 
No, there is no provision in the LinkMasterFields and LinkChildFields for
linking to another subreport, unless you embed the second subreport in the
first one. That does not mean you cannot mangage a relationship using VBA
code, for example.

If you can clarify somewhat, perhaps someone can offer a useful suggestion.

Larry Linson
Microsoft Access MVP
 
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
 
Back
Top