Barcode for SSRS > Generate Barcode in SSRS

How to Generate Barcodes in Reporting Services

How to Create Linear & 2D Barcodes in SQL Server Reporting Services (SSRS) 2005 & 2008
  • Reliable and robust barcode library complying with Reporting Services 2005 and 2008
  • 100% compiled in Visual C# for barcode generation for SQL Server Reporting Services
  • Create barcodes in SQL Server Reporting Services (SSRS) with a Custom Report Item (CRI)
  • Easily generate and draw high-quality linear &2D barcode images in Reporting Services
  • Support multiple barcode image formats, like GIF, BMP, PNG, JPEG, TIFF, etc
  • Simply configure and adjust generated barcode size, color, rotation, fonts, human-readable text, etc
  • Provide perpetual and flexible royalty-free developer license with purchase of this Barcode SDK
Download KA.Barcode for Reporting Services
Term Limitation
Developers are free to use KA.Barcode for Reporting Services evaluation without term limitation.
Evaluation Restriction
Restriction of our evaluation version is that a "KA Barcode" watermark will appear on generated barcode images. As a result, commercial applications are not permitted. If business applications are required, please buy our applicable license versions to generate barcode images without watermark.
Installation & Preparation

Please unzip this trail package and you can find four dlls in the package, including "KeepAutomation.Barcode. SSRS2005.dll", "KeepAutomation.Barcode.SSRS2005CRI.dll", "KeepAutomation.Barcode.SSRS2008.dll", and "KeepAutomation.Barcode.SSRS2008CRI.dll". Refer to provided tutorial to generate required barcode images.
Deploy the Control for Barcode Generation
For Reporting Services 2005 Porject:
  1. Open directory "\Program Files\Microsoft Visual Studio8\Common7\IDE\PrivateAssemblies\"
  2. Copy "KeepAutomation.Barcode.SSRS2005CRI.dll" and "KeepAutomation.Barcode.SSRS2005.dll" to the folder.
  3. Open another directory "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\"
  4. And then copy "KeepAutomation.Barcode.SSRS2005CRI.dll" to the folder.
For Reporting Services 2008 Porject:
  1. Open directory "\Program Files\Microsoft Visual Studio9.0\Common7\IDE\PrivateAssemblies\
  2. Copy "KeepAutomation.Barcode.SSRS2008CRI.dll" and "KeepAutomation.Barcode.SSRS2008.dll"to the folder.
  3. Open another directory "\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\"
  4. Copy "KeepAutomation.Barcode.SSRS2008CRI.dll" to the folder.
Pre-Configuration for the Barcode Generation
For Reporting Services 2005 Porject:

1. Open directory "\Program Files\Microsoft Visual Studio8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config" with TXT editor.

<Configuration>
<Extensions>
...
<ReportItems>
<ReportItem Name="BarCodeControl"
Type="KeepAutomation.Barcode.SSRS2005CRI.BarCodeReportCRI, KeepAutomation.Barcode.SSRS2005CRI" />
</ReportItems>
<ReportItemDesigner>
<ReportItem Name="BarCodeControl"
Type="KeepAutomation.Barcode.SSRS2005.BarCodeReport, KeepAutomation.Barcode.SSRS2005" />
</ReportItemDesigner>
</Extensions>
</Configuration>
2. Open file "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config" with TXT editor.

<Configuration>
<Extensions>
...
<ReportItems>
<ReportItem Name="BarCodeControl"
Type="KeepAutomation.Barcode.SSRS2005CRI.BarCodeReportCRI, KeepAutomation.Barcode.SSRS2005CRI"/>
</ReportItems>
</Extensions>
</Configuration>
3. Open file "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsssrvpolicy.config" with TXT editor.

<configuration>
<mscorlib>
<security>
<policy>
<PolicyLevel version="1">
...
<!-- This is the first CodeGroup in the config file -->
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="Nothing">
<IMembershipCondition
class="AllMembershipCondition"
version="1" />

<!-- Add Following Text just follow the first CodeGroup. -->
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants KeepAutomation.Barcode.SSRS2005CRI.dll Full Trust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\
ReportServer\bin\KeepAutomation.Barcode.SSRS2005CRI.dll" />
</CodeGroup>
...
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>
For Reporting Services 2008 Project:

Open directory "\Program Files\Microsoft Visual Studio9.0\Common7\IDE\PrivateAssemblies\ RSReportDesigner.config" with TXT editor.
Refer to the above statement and change 2005 to 2008.

Open file "\Program Files\Microsoft SQL Server\MSRS10. MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config" with TXT editor.
Refer to the above statement and change 2005 to 2008.

Open file "\Program Files\Microsoft SQL Server\MSRS10. MSSQLSERVER\Reporting Services\ReportServer\rsssrvpolicy.config" with TXT editor.
Refer to the above statement and change 2005 to 2008.

Note that, the directory [MSSQL.3] is maybe MSSQL.1, MSSQL.2, or MSSQL.4 for different machines.
How to Create Barcodes for Reporting Services
  1. Click "Business Intelligence Projects" in Visual Studio, then choose "Report Server Project Wizard" template.
  2. To choose data source, select "AdventureWorks" in "Connection Properties" form and then click "Next".
  3. Create the Query string and input "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer". Choose "Tabular" and then click "Next".
  4. Select default setting of "Design the Table", "Choose the Table Style" and "Choose the Deployment Location" then click "Next".
  5. Name the report "Barcode in Reporting Service", click "Finish". Display the toolbox, and navigate to "KeepAutomation.Barcode.RS2005CRI.dll" and add it as item on toolbox.
  6. Add a column to display the barcode images and name it "Barcode", then drag and drop the "LinearBarcodeControl" to the "Barcode" column.
  7. Select "BarcodeData" in "Properties" window and change it to "=Fields!AccountNumber.Value". Now, it is allowed to preview the report by clicking "Preview" tab.
Attention, here our test environment is for SSRS 2005 project. If you want to create barcodes for SSRS 2008 project, just change "2005" into "2008" respectively.
Download Free TrialInstallation & PreparationBarcode in .NET SSRSUsing ASP.NETUsing .NET WinformsData Matrix for SSRSPDF417 for SSRSQR Code for SSRSmoreCodabar for SSRSCode 39 for SSRSCode 128 for SSRSEAN-8 for SSRSEAN-13 for SSRSEAN 128 for SSRSIntelligent Mail for SSRSInterleaved 2 of 5 for SSRSISBN for SSRSITF-14 for SSRSRM4SCC for SSRSUPC-A for SSRSUPC-E for SSRSmore
KeepAutomation provides complete barcode automation solutions for add barcode display 2-dimensional, barcode generation capacity api, and barcode mobile applications. We recommend the customers use high quality ASP.NET html5 document viewer, c# pdf sdk, C# merge PDF files, Split PDF in C#, C# View, edit PDF online , C# Convert PDF to Tiff, C# Convert PDF to text, txt, .net imaging sdk, C# PDF metadata edit from RasterEdge.com.