One page of same labels

[Former Member]

I have written a simple label report using the Crystal XI Label Wizard. It prints out specific inventory item information and is set to use the Selection Expert to restrict the report to one inventory item only. I need the report to print out ONE sheet of labels for that inventory item but when I restrict the report to just the one item I end up with only one label printing on the page (the rest are blank). Does anyone know how to get it to give me an entire page of the same label (much like in Word how you can select to print one page of the same label). Any help would be great!

[Former Member · Accepted solution]

Here are a couple of suggestions:

1) Don't use the label wizard! Make your detail format the size of the page, and manually add each field in each spot where a label would be. Eg:

{product.code}                  {product.code}                {product.code}
{product.sku}                   {product.sku}                 {product.sku}


{product.code}                  {product.code}                {product.code}
{product.sku}                   {product.sku}                 {product.sku}



{product.code}                  {product.code}                {product.code}
{product.sku}                   {product.sku}                 {product.sku}

2) Use the label wizard, then use a database command that will duplicate the records as many times as there are labels on the page. Eg:

select into #temp code, sku from product where code = '{?Prod Code Selection}'
select into #temp2 * from #temp
insert into #temp2 select * from #temp
insert into #temp2 select * from #temp
insert into #temp2 select * from #temp
insert into #temp2 select * from #temp
...
select * from #temp2

HTH,

Carl