Mailing labels don't display properly when run from report server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GORAMS - 11 Oct 2005 21:05 GMT

I have some mailing labels that when I run it from my report works fine as
two columns. When I deploy it to the report server and run it from there it
only displays one column. Anyone have any information that could help solve
this?

Reply to this Message

Robert Bruckner [MSFT] - 13 Oct 2005 05:00 GMT

When viewing the report in HTML format e.g. in report manager, you will only
see one column because multiple columns are currently not supported in HTML
format. You will however get them when using PDF export.

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

>I have some mailing labels that when I run it from my report works fine as
> two columns. When I deploy it to the report server and run it from there
> it
> only displays one column. Anyone have any information that could help
> solve
> this?

Reply to this Message

GORAMS - 13 Oct 2005 13:18 GMT

Thanks so much for your reply. I was able to run the report and when I
exported them out to a PDF format, it properly displayed my report.

> When viewing the report in HTML format e.g. in report manager, you will only
> see one column because multiple columns are currently not supported in HTML
[quoted text clipped - 9 lines]
> > solve
> > this?

Reply to this Message

Labhesh Shrimali - Bangalore - 23 Oct 2005 06:20 GMT

Hi,
Just want to know how did you use label priting in MC Repots. because as far
as my knowle'ge i can have only one row at a time.
I am unable to print label with three column.

Any help?
Labhesh Shrimali
Bangalore

> Thanks so much for your reply. I was able to run the report and when I
> exported them out to a PDF format, it properly displayed my report.
[quoted text clipped - 12 lines]
> > > solve
> > > this?

Reply to this Message

Parker - 23 Oct 2005 17:43 GMT

Make the height of the body of the report small enough so that several
rows will print on one page - also, set up the body of the report to
have three columns.

You need to carefully control the size of the page, the body of the
report, and any page header and footer.

Reply to this Message

Dan Storch - 18 Oct 2006 19:49 GMT

This is a great feature but can reporting services print records left to
right rather than top to bottom. For Example, I want to print the records in
order like this

1 2
3 4

rather than
1 3
2 4

Thank you for your time.
Dan

> Make the height of the body of the report small enough so that several
> rows will print on one page - also, set up the body of the report to
> have three columns.
>
> You need to carefully control the size of the page, the body of the
> report, and any page header and footer.

Reply to this Message

Parker - 16 Nov 2006 12:01 GMT

Dan -

If you read this, the only way I can think of is to do the work in a
stored procedure to combine two (or more) records into one - and then
print the resulting record on a single row.

I had to do something like this when I needed to put 4 records on a
page (one in each corner) and duplex print them.

> This is a great feature but can reporting services print records left to
> right rather than top to bottom. For Example, I want to print the records in
[quoted text clipped - 9 lines]
> Thank you for your time.
> Dan

Reply to this Message

mbsqlnewbie - 30 Jul 2007 18:02 GMT

HI Dan,
Were you ever able to figure out how to get the labels to print from left to
right rather than down the page?
Any help would be greatly appreciated!
Thanks!

> This is a great feature but can reporting services print records left to
> right rather than top to bottom. For Example, I want to print the records in
[quoted text clipped - 16 lines]
> > You need to carefully control the size of the page, the body of the
> > report, and any page header and footer.

Reply to this Message