Single record in, multiple records out

[ebarr727]

I am relatively new to Crystal. My ultimate goal with this project is to print multiple 'mailing' labels for each patient. The user wants a sheet of labels per patient. I used label wizard but that gives me one label per patient. I thought the best way would be to read the db and create 30 records per patient and then pass those to label wizard. Is there a quick way to print 30 records per incoming record?

 

[Madawc]

If the label is a detail line, right-click and insert a section below, then use copy-and-paste to repeat the lable fields. Repeat till you have 30.

Or if you can add tables to the database, create a dummy table with 30 records. Link this to the real record ore records, and now you have 30 detail lines.

You could also probably do this by linking to an Excel spreadsheet separate from the database, but I've not done this myself.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[ebarr727]

Purrrfect. That worked. Thanks!