Home Dashboard Directory Help
Search

How to Print 2.75Inch X 1.43Inch label as Portrait in SSRS report.SSRS assumes Landscape by vitthal bhovi


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 785355
Opened: 4/22/2013 10:49:34 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

Hi,

I have a SSRS 2008 report form that is printing to a label printer. The Page sizes are set to 2.75Inch wide by 1.43Inch hight. Since there is no paper orientation in SSRS, it is assuming this to be a landscape report when it should be a portrait.

The users are able to export to a PDF and print after adjusting the print settings (orientation to portrait), but the extra clicks to produce/print the pdf's are unacceptable.

Is there a way to force the SSRS report print portrait.


Regards,

Vitthal

Details
Sign in to post a comment.
Posted by Microsoft on 6/2/2014 at 3:12 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.
Matt Jones
SSRS Tiger Dev Team
Posted by Microsoft on 5/14/2014 at 10:28 AM
Hello,

Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information. I'm aware of this limitation in SSRS, and we don't track the orientation in the RDL, just the height and width and based the orientation flag we send to the printer based on whichever is great.er. I've read some posts online with folks being able to workaround this issue. Have you tried any of these solutions?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/15552161-f3ef-4e78-be7e-8b4595151f48/ssrs-label-to-zebra-printer?forum=sqlreportingservices
http://stackoverflow.com/questions/15244336/printing-in-landscape-or-portrait-automatically-rotates-text-ssrs

You can find a blog on MSDN describing the functionality here:
http://blogs.msdn.com/b/bwelcker/archive/2005/08/19/alien-lanes-_2800_logical-and-physical-pagination-rules_2900_.aspx

Also, you might consider creating a report with height = width (e.g. if you want 4"x3", make it 4"x4" and configure the printer to clip the extra content if possible).

Thanks,
Matt Jones
SSRS Tiger Dev Team
Posted by Jonathon Nelson on 6/18/2013 at 10:22 AM
I am having the exact same issue. I've tried both Zebra label printers, and DataMax label printers which are popular printers on a manufacturing shop floor. Vitthal is correct that the orientation is not explicitly set in the RDL. The report designer interface appears to allow you to set the orientation to portrait or landscape, but only the pageheight and pagewidth are persisted in the RDL. Changing the orientation will "flip" the height/width settings in the report designer, and a change in the height/width settings MAY "flip" the orientation setting, but this is all an illusion of the interface.

My label is 4"wide by 3" tall. These label printers know how to "rotate text", which is not the same as orientation. I need the label to be printed with the text reading across the width of the label (the long side), but the text will be rotated 90 degrees because SSRS (or the ActiveX control or something) can't understand why it doesn't have to tell the printer to be in landscape mode, thus rotating the text. I have found NO acceptable workaround for this without requiring the user to manually change settings in the printer properties each and every time a label must be run.

Other failed attempts:

Setting the report size to 3x3 works, except I can't print anything in the last vertical inch of the label. If I try, it will wrap and print on two labels.

Setting the report size to 4x4 causes the print to span 2 labels, even if I don't exceed 3" of data vertically.
Sign in to post a workaround.