Multiple Subreports in One Report - Error

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

Guest

First of all thank you for reading this.

I have a report that displays actions of a Case. tblCase holds the case
information and the related table tblActions hold the actions performed on a
case. My supervisors want me to seperate the actions into columns (not
vertically, this would be easy.) I have main report call the tblCase. I have
three subreports that call the tblActions. Each subreport has different
crietieria. The first gets actions that with date in specified range and the
second gets actions in another specified range and the third grabs the
actions that haven't been completed.
Every time I run the report I get an infinite loop. I suspect that it has to
do with the subreports b/c everytime I delete one the subreports, the report
will output correctly.

Any help?! I have been working on this problem for a while and anything
that you think can help please let me know.
 
Funny you should have this problem - I had the exact same situation! I have a
main report with three subreports. I had all three subreports defined in the
detail section. I think my problem was that if any of the subreports
contained enough details to go beyond a single page I got hung up. My
solution was to place all three subreports in a section header for the field
to which they were linked and then it worked.

I'm not sure if it wll work for you, but you might try it. - Good luck!
 
We are on the right track. I created a visible header for the intCaseID
field, the field that links the tables. I copied the three subreports to the
intCaseID header and I still got a inifinite loop. However, if I change the
properties of the subreport to CanGrow = No, it works. Any more advice?

Thanks for your post.

Thanks,
Augustine
 
The infinite loop is usually caused by setting a group
header section's Repeat Section property to Yes in
conjunction with some other property such as KeepTogether,
CanGrow, ForceNewPage, or something that will cause a page
to be formatted only to determine that it won't fit so it
has to back up and do it again. Conditionally setting a
RepeatSection header to be invisible or Cancelling its
Format event will also cause an infinite loop.

A serious pain, but the easiest thing to do is set
RepeatSection to No. If you have a real need for repeating
the section, then play around with the other properties to
see if you can live with whatever combination you can get to
work.
 
All my subreports and my section header have CanGrow = Yes - otherwise it
doesn't print out all my details. Only the middle report has enough data to
go beyond a single page, but it seems to work.

Sorry I can't be of more help. Good luck!
 
Marsh thank you!

It worked.

Marshall Barton said:
The infinite loop is usually caused by setting a group
header section's Repeat Section property to Yes in
conjunction with some other property such as KeepTogether,
CanGrow, ForceNewPage, or something that will cause a page
to be formatted only to determine that it won't fit so it
has to back up and do it again. Conditionally setting a
RepeatSection header to be invisible or Cancelling its
Format event will also cause an infinite loop.

A serious pain, but the easiest thing to do is set
RepeatSection to No. If you have a real need for repeating
the section, then play around with the other properties to
see if you can live with whatever combination you can get to
work.
--
Marsh
MVP [MS Access]


ac_NAK said:
We are on the right track. I created a visible header for the intCaseID
field, the field that links the tables. I copied the three subreports to the
intCaseID header and I still got a inifinite loop. However, if I change the
properties of the subreport to CanGrow = No, it works. Any more advice?
Click to expand...
Click to expand...
 
Thanks Liz.

Liz Taylor said:
All my subreports and my section header have CanGrow = Yes - otherwise it
doesn't print out all my details. Only the middle report has enough data to
go beyond a single page, but it seems to work.

Sorry I can't be of more help. Good luck!
Click to expand...
 
Back
Top