No Data on one of 6 Subreports

[Cydney]

Hi. I have a Main Report with 6 subreports on it.

One of these subreports will occasionally have no data in it. When that
happens, the subreport (which also contains another subreport within it)
hangs up the whole main report. How can I prevent that subreport for causing
a problem for all the rest? I have tried putting a "Cancel" event "on no
data" for the subreport, but that doesn't seem to help either. What am I
missing?
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson

 

[Marshall Barton]

Hi. I have a Main Report with 6 subreports on it.

One of these subreports will occasionally have no data in it. When that
happens, the subreport (which also contains another subreport within it)
hangs up the whole main report. How can I prevent that subreport for causing
a problem for all the rest? I have tried putting a "Cancel" event "on no
data" for the subreport, but that doesn't seem to help either. What am I
missing?

I think you might be missing something odd in the main
report or its code. Subreport's with no data require
nothing extra and will not display anything.

What do you mean by "hangs up the whole main report"? The
only thing I remember seeing that causes a report to go into
an infinte loop is in A2002 when code is used to hide (or
??) a Repeat group header section.