Page break control when printing subreport

[mike99]

I need a report that prints shipping labels and the number of labels depends on the quantity of items sold.
I have developed a main report that does not print anything but passes the quantity sold information to a sub report via a link. The sub report generates the correct number of labels.
The sub report is inserted into the detail line on the main report.
Everything works fine except that the report sometimes skips to a new page after printing the labels for one product. I want the report not to skip. I cannot see any pattern in when it does and does not skip.

Any help will be appreciated

 

[AndrewBaines]

Why are you using the subreport? Is it not possible to just do a group select against sales quantity?
Performance will improve greatly. Andrew Baines
Chase International

 

[mike99]

Previous advise from the list was to create a table that has the format:
1
2
2
3
3
3
etc. and link the quantity sold field to this table to generate the duplicate labels required. I was unable to establish a link to either an Access or Pervasive table from Busines Vision with Crystal Ver 8.0. I got round the problem by linking through a sub report and passing the label info down to the sub report.