Report hangs on certain criteria

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have an Access ADP with a repots and sub report.

Basically, there are about 7 subreports. The main report (rptStyles)
creates a PROFILE of a design style. This profile has subreports that
present the characteristics of the style.

Each style comes in mutiple sizes (rptStylesSizesSubreport)
Each style comes in mutiple colors (rptStylesColorsSubreport)
Each style has multiple components (rptStylesComponentsSubreport)
etc...

Each subreport is linked as the parent = StyelID and child = StyleID

The report works PERFECTLY for about 90% of the styles for which we generate
the report. The report is setup to filter by style (only one page report
result) of for an entire season (generates a 15-20 page report).

The problem is that for a few of the styles, the report "hangs" and never
gets generated. I have walked through the code and it hangs when the report
is generated (as opposed to when a certain criteria is being determined).

I have tried to open each of the subreports separately with the filter
manually set to the style number to see if one of the subreports is hanging
the report and each subreport opens without a problem.

Does anyone have any idea what is causing this "hang"? Is there any other
tools or techniques I can use to debug why only these few are hanging? I
cannot seem to see any difference in the data (i.e. certain fields are
empty, etc.).

Help?
 
Stephen

Always the same styles hanging up, or always some style (but not the same
one each time)?

Have you tried a process of elimination and started with testing a main
report only (no subreports), then adding one subreport and re-testing, then
.... until it breaks?

Just a couple thoughts...

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top