R
rowiga
I have a report with 2 subreports. The report is actually a recipe.
The main report contains basic recipe information and contains the field
RecipeID.
Each of the subreports (rptIngredients and rptPreparation) link to the main
report using RecipeID.
If I view the report filtered for the current record on my form everything
works fine. Even if I have 15-20 records selected the report prints
fine...but ...if I try to print all records in the database (currently 220
recipes) the report freezes. The status bar says "formatting page" and I have
to use Ctrl+Break to get out. Even if I'm in print preview and I use the
button to advance to the last record I get the same thing. If I advance
through the report page-by-page I get to about 48 records then the report is
blank for the remaining pages. I ran the report analyzer that said to add an
Option Explicit statement for the report, which I've done, but I still have
this problem.
Any ideas?
TIA
Bob
The main report contains basic recipe information and contains the field
RecipeID.
Each of the subreports (rptIngredients and rptPreparation) link to the main
report using RecipeID.
If I view the report filtered for the current record on my form everything
works fine. Even if I have 15-20 records selected the report prints
fine...but ...if I try to print all records in the database (currently 220
recipes) the report freezes. The status bar says "formatting page" and I have
to use Ctrl+Break to get out. Even if I'm in print preview and I use the
button to advance to the last record I get the same thing. If I advance
through the report page-by-page I get to about 48 records then the report is
blank for the remaining pages. I ran the report analyzer that said to add an
Option Explicit statement for the report, which I've done, but I still have
this problem.
Any ideas?
TIA
Bob