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

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?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
This posting is provided "AS IS" with no warranties, and confers no rights.
"GORAMS" <GORAMS@.discussions.microsoft.com> wrote in message
news:EE7C98FE-8D7A-4BBD-9057-48B68A71140D@.microsoft.com...
>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?|||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.
"Robert Bruckner [MSFT]" wrote:
> 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
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "GORAMS" <GORAMS@.discussions.microsoft.com> wrote in message
> news:EE7C98FE-8D7A-4BBD-9057-48B68A71140D@.microsoft.com...
> >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?
>
>|||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
"GORAMS" wrote:
> 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.
> "Robert Bruckner [MSFT]" wrote:
> > 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
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "GORAMS" <GORAMS@.discussions.microsoft.com> wrote in message
> > news:EE7C98FE-8D7A-4BBD-9057-48B68A71140D@.microsoft.com...
> > >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?
> >
> >
> >|||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.|||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
"Parker" wrote:
> 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.
>|||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.
Dan Storch wrote:
> 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|||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!
"Dan Storch" wrote:
> 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
> "Parker" wrote:
> > 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.
> >
> >

Mailing Labels

Is it possible to do mailing labels through Reporting Services. I can't
figure out a way to display three columns of information per page'?
anybody have any examples?I set up a report to print Avery 5162 labels yesterday. I had to play with
the margins, font size, textbox positioning, and textbox spacing to get the
data to fit on the labels correctly. After adding a blank report and creating
a dataset here are the steps I took to create the report.
Hope it helps. 1) Change Report Properties Margins to: 0.125in, 0.125in,
0.825in, 0in (Your's will probably be different.)
2) Change Body Layout Properties: Columns=2, ColumnSpacing=0.25in, Size=4in,
1.375in(the label size)
3) Add a List object: Location=0in, 0in, Size=4in, 1.375in(the label size)
4) Add a Rectangle object: Location=0in, 0in, Size=4in, 1.375in(the label
size)
5) Add and arrange data fields When you first view the report on the Preview
tab it will only show one column. You'll need to switch to Print Preview to
see the two column report.|||Thanks.. .I actually already did practically the same thing.... take care...
"GORAMS" wrote:
> I set up a report to print Avery 5162 labels yesterday. I had to play with
> the margins, font size, textbox positioning, and textbox spacing to get the
> data to fit on the labels correctly. After adding a blank report and creating
> a dataset here are the steps I took to create the report.
> Hope it helps. 1) Change Report Properties Margins to: 0.125in, 0.125in,
> 0.825in, 0in (Your's will probably be different.)
> 2) Change Body Layout Properties: Columns=2, ColumnSpacing=0.25in, Size=4in,
> 1.375in(the label size)
> 3) Add a List object: Location=0in, 0in, Size=4in, 1.375in(the label size)
> 4) Add a Rectangle object: Location=0in, 0in, Size=4in, 1.375in(the label
> size)
> 5) Add and arrange data fields When you first view the report on the Preview
> tab it will only show one column. You'll need to switch to Print Preview to
> see the two column report.