Barcode for SSRS 2005 Developer Guide
To generate high quality barcode images in SQL Server Reporting Services 2005 with barcode generator SDK
Download .NET Reporting Service Barcode Generator Evaluation Package
Purchase Reporting Service Barcode Generator SDK License
"Problem solved! Thank you for your patient support!"
- Martin Reed, US

Linear & 2D Barcode Generating in SQL Server Reporting Services 2005

  • Generate Barcodes in Microsoft Reporting Services 2005
  • Drag and drop Barcode Custom Report Item (CRI) to your report layer pages
  • High quality barcode images in GIF, PNG, JPEG & BITMAP
  • Completely developed in Visual C#.NET 2005
  • Mature barcode generating components for Reporting Services using .NET Barcode Generator control
.NET Barcode for Reporting Service is the most flexible and powerful .NET Component (.NET dll Class Library) which lets you to easily and simply add advanced barcode generation in your Microsoft SQL Server Reporting Service projects.
To generate barcode in SQL Server Reporting Services 2008, please go to Barcode Generator for Reporting Service 2008 Guide.
SSRS 2005 Barcode - Deploy Barcode Controls
Top
  • Open directory "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\".

    Copy "OnBarcode.Barcode.RS2005CRI.dll" and "OnBarcode.Barcode.RS2005.dll" to the folder

  • Open directory "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\"

    Directory [MSSQL.3] is machine specific. It might be MSSQL.1, MSSQL.2, or MSSQL.4.

    Copy "OnBarcode.Barcode.RS2005CRI.dll" to the folder
SSRS 2005 Barcode Generator - Config Environments
Top
  • Open the file with your TXT editor:

    "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\rsreportdesigner.config"
  • <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.LinearReportCRI, OnBarcode.Barcode.RS2005CRI" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2005CRI" />
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2005CRI" />
          <ReportItem Name="QRCodeBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2005CRI" />
        </ReportItems>
        <ReportItemDesigner>
          <ReportItem Name="LinearBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005.LinearReport, OnBarcode.Barcode.RS2005" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005.DataMatrixReport, OnBarcode.Barcode.RS2005" />
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005.PDF417Report, OnBarcode.Barcode.RS2005" />
          <ReportItem Name="QRCodeBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005.QRCodeReport, OnBarcode.Barcode.RS2005" />
        </ReportItemDesigner>
      </Extensions>
    </Configuration>
    

  • Open file: "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config"

    Directory [MSSQL.3] is machine specific. It might be MSSQL.1, MSSQL.2, or MSSQL.4.
  • <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.LinearReportCRI, OnBarcode.Barcode.RS2005CRI"/>
          <ReportItem Name="DataMatrixBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2005CRI"/>
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2005CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2005CRI"/>
          <ReportItem Name="QRCodeBarcodeControl"
          	  Type="OnBarcode.Barcode.RS2005CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2005CRI"/>
        </ReportItems>
      </Extensions>
    </Configuration>
    
  • Open file: "\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config"

    Directory [MSSQL.3] is machine specific. It might be MSSQL.1, MSSQL.2, or MSSQL.4.
  • <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. -->
                <!-- You need change "MSSQL.3", if your directory is MSSQL.1, MSSQL.2, or MSSQL.4 -->
                <CodeGroup
                  class="UnionCodeGroup"
                  version="1"
                  PermissionSetName="FullTrust"
                  Description="This code group grants OnBarcode.Barcode.RS2005CRI.dll
    			        Full Trust permission. ">
                  <IMembershipCondition
                    class="UrlMembershipCondition"
                    version="1"
                    Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
                      		bin\OnBarcode.Barcode.RS2005CRI.dll" />
                </CodeGroup>
    
                ...
    
              </CodeGroup>
            </PolicyLevel>
          </policy>
        </security>
      </mscorlib>
    </configuration>
    
How to generate barcodes in Reporting Services 2005 reports in Visual Studio 2005 and later version?
Top
  1. Start Visual Studio 2005, and create a new project. In "New Project" dialog,
    1. Select "Business Intelligence Projects" as project type
    2. Select "Report Server Project Wizard" as template
    3. Use the default name "Report Project1" as report name


  2. Click "Next" in Report Wizard dialog, and use "AdventureWorks" as our data source. After that, click Next to proceed.



  3. Now copy "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer" to the query string input box.



  4. Select "Tabular" as report type.
  5. Use the default settings in "Design the Table" Dialog, and click Next.
  6. Use the default settings in "Choose the Table Style" Dialog, and click Next.
  7. Use the default settings in "Choose the Deployment Location" Dialog, and click Next.
  8. Name the report "Barcode in Reporting Service 2005" and click Finish.



  9. Now you need to add OnBarcode Reporting Service Barcode CRI to your Report Item Toolbox.
    1. Right click "Report Items"
    2. Click "Choose Items..."
    3. Select tab ".NET Framework Components"
    4. Click "Browse..." button
    5. Select "OnBarcode.Barcode.RS2005.dll" from "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\"
    6. Check the 4 barcode components for reporting service "DataMatrixBarcodeControl", "LinearBarcodeControl", "PDF417BarcodeControl", "QRCodeBarcodeControl". Click OK
    7. Now you can find 4 barcode components in your Report Item Toolbox.


  10. Add a new column to your report to display barcodes. In this example, we will use Code128 to encode Customer Account number.
    1. Right click the table in the report, select "Insert Column to the Right"
    2. Key in "Barcode" as column header
    3. Drag "LinearBarcodeControl" to the Column "Barcode"
    4. Select linear barcode, go to Property window and change property "BarcodeData" to "=Fields!AccountNumber.Value"




  11. Click "Preview" tab to view the generated report.

SSRS 2005 Barcode Generator Supported Barcode Types
Top

Barcode Library for Reporting Service - Barcode Image Generation

OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding, VB.NET Barcode Image, Java JSP Servlet. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.