Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

Mailing label report in reporting services using asp.net 2008

Dear Experts,

I have one web application with asp.net 2008 with reporting services inbuilt.  I am trying to make one mailing label report using vs.net studio.  I have defined following margins for the report.

In report properties-> layout tab.

Columns : 3
Spacing : 0.14

In Body Properties :
Width : 2in
Height : 1.125in

Then in body, i have taken one table with single cell and in that i have added Address field that i want to print as label.

When i preview the report in my asp.net page it displays only single column on page and other columns on next page. But when i export the same report in PDF format, it displays the report properly in a single page 3 columns.

Am i doing something wrong?

Please help.

Thanks and Regards
Subodh Anant Mestry
0
swarajya
Asked:
swarajya
  • 5
  • 3
1 Solution
 
Auric1983Commented:
No you aren't doing anything wrong.

There is a limitation in the Reporting Services rendering engine that cannot represent columns when viewed certain ways.
0
 
Auric1983Commented:
If you Export to TIFF or PDF it will work, or printing according to the info I can find.

Sorry I had a link to an old MS KB article about this, but can't seem to find it now. Will keep searching
0
 
swarajyaAuthor Commented:
Is there any solution for this problem?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Auric1983Commented:
Unfortunately the only solution I was ever able to find was to export to PDF (or TIFF) and print from there.
0
 
swarajyaAuthor Commented:
This is not a solution for my question
Please close this question.
0
 
Auric1983Commented:
swarajya,

Please see the "newsletter-style columns" heading on this MS article. Particularily and I quote "Columns are only applied when you render and print reports in PDF or Image" This is a known issue with SSRS.  There is no known solution for this, only work arounds, such as rendering to image or PDF first and then printing.

http://msdn.microsoft.com/en-us/library/bb677374.aspx
0
 
swarajyaAuthor Commented:
This is not the complete solution for me as i need to show the columns in columnar format
0
 
Auric1983Commented:
What about setting up a schedule to automatically deliver the document in PDF or Tiff format so that it is rendered correctly?  

Conversely you can also create a custom link that automatically renders to PDF so the users don't have extra steps...
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now