Workaround for Landscape printing if Report Width is bigger than Height in Reporting Services

Recently, a customer who was using our Barcode Professional for Reporting Services contacted us about an issue with printing orientation. He was designing a barcode label which Width (4in) was bigger than the Height (2in) i.e. a common label shape/format. He pointed out that when printing such report to a label thermal printer, SSRS changes from portrait to landscape without any reason! He also commented us that it seems that SSRS does that “by design” i.e. the logic that SSRS uses is this: if the report’s width is greater than height, then Landscape printing is performed! (Who was the brilliant mind behind this design?) Our customer just wanted to know if we were aware of such behavior and if we knew of some fix as the one provided at MS SQL Server forums was totally cumbersome.

After discussing this with our team, we suggested to our customer to try the following. We told him to set his report to be 4in x 4in i.e. a square shape and then design the reports by using just the top 2in zone leaving the rest just blank. What was the end result? SSRS performed portrait printing and issue was solved! Hope this workaround helps to others experiencing the same issue.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: