<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Create Label Printing Report in SSRS

Published on
13,190 Points
7,090 Views
1 Endorsement
Last Modified:
Approved
Hi,

I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Builder. Because, all are used to with BIDS to creates report.

The label printing is possible using the Report builder and it is available in SSRS. To get opened the Report builder open SSRS report server and open Report builder Link. see image below:

Reprot Server
REport Builder
When you open the Report builder it will ask to Report Templates (Tablix, Blank etc.) as like crystal report. From the list select the Blank template and start to work as normal BIDS environment.

First set the Report Layout and size of the report.

Set Body width
 

It’s good to set all report properties (different margins) to print report appropriate on paper.

After setting margins for report set the columns for the Label printing report. It’s obvious thing for label printing to set columns per page. i.e If you want to print 3 label on single row then set 3 columns. see image below to set the columns.

Set Reprot Layout
When you set the columns, you will get the view of report as below (3 column view)

Layout
Hope, all settings are completed for the Label printing report. Now, its time to design or place the field which you want to print in label. (Obvious to print name of person, Address, City, Phone etc.)

To do that follow the normal data source and dataset creation steps.

1. Create data source or select existing shared source.

2. Write query or use Store procedure to get result set from the Database.

It’s over to get result from database.

You can see the Created data set in the left pane (Report data). Just drag and drop the Fields which you want. At last you report will look like as image below:

REport Desing
You can preview this report using the Run button on Top-Left corner and select the print layout to see actual layout of Label printing. see image below:

Printable Report format
That’s it for now, hope you leaned something new from me. Please revert back to me if you have any queries.

Thanks,

Alpesh
Untitled3.png
1
2 Comments
LVL 4

Expert Comment

by:rshq
Hi
 when i run project only column 1 has data and 2 other columns is empty!
0

Expert Comment

by:Azhar Hussain
it does not work, not sure how come you are doing this
0

Featured Post

CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Basic Overview of office 365 user portal
Watch this online video tutorial and learn the best way to reduce Outlook mailbox size using Compact Now feature of Outlook. It removes the deletes item's space from Microsoft Outlook 2016, 2013, and 2010 and compresses the PST file size. This will …
Next Article:

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month