all groups > sql server reporting services > april 2006 >
You're in the

sql server reporting services

group:

Problem Printing Labels using subreports


Problem Printing Labels using subreports shane
4/18/2006 3:03:02 AM
sql server reporting services:
Hi,

I have a report for printing order delivery labels. Each order can have
multiple delivery addresses, so this is a nested report with the order report
running first and then the delivery address report running as a sub-report.

The problem is that I want to set the labels so that up to 4 different
delivery addresses for the same order could be printed on a single page.

I am not sure how to set the layout of the sub report, currently it prints
each delivery address 4 times on a page as opposed to 4 different delivery
addresses.

If the order had 5 different delivery addresses, I would need the first page
to show the first 4 and the second page to just show 1 address with 3 blank
labels.

Has anyone any experience of this or does anyone know how to set this up?
RE: Problem Printing Labels using subreports Stevie
4/27/2006 7:45:01 PM
When I needed to print labels, I found a site that had premade report
templates that saved me a bunch of time.
http://www.reportpax.com
They should work in your case. The only drawback is that you have to pay for
them but the support was good.

[quoted text, click to view]
AddThis Social Bookmark Button