I'm totally at a loss and hoping for some new insight. I've got a report and
subreport. They are linked by Customer Name, System Location, Type of
System, Service, Week, Day. The report displays the customer name, system
location and type of system. The subreport displays a list of systems. It is
set up this way because customers have multiple locations with systems and
only one location can be on a report. This information is then printed on a
preprinted form. My problem comes in that there is only room for 20 systems
to be listed (subreport) on the preprinted form. Once the 20 systems has
been reached, I need to have a new report with all the same customer name,
location, etc. but with the remaning systems listed. I'm looking for a
simple efficient way to accomplish this...Any suggestions?????

Thank you for any thoughts....

Hi Tia,

Don't really get what you want but you may want to check this link below
from MVP Allen Brown first.

http://allenbrowne.com/ser-39.html

--
niuginikiwi
Nelson, New Zealand


"Tia" wrote:

> I'm totally at a loss and hoping for some new insight. I've got a report and
> subreport. They are linked by Customer Name, System Location, Type of
> System, Service, Week, Day. The report displays the customer name, system
> location and type of system. The subreport displays a list of systems. It is
> set up this way because customers have multiple locations with systems and
> only one location can be on a report. This information is then printed on a
> preprinted form. My problem comes in that there is only room for 20 systems
> to be listed (subreport) on the preprinted form. Once the 20 systems has
> been reached, I need to have a new report with all the same customer name,
> location, etc. but with the remaning systems listed. I'm looking for a
> simple efficient way to accomplish this...Any suggestions?????
>
> Thank you for any thoughts....