Barcode Creation in Reporting Service 2008 Guide
To generate high quality barcode images in SQL Server Reporting Services 2008 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 2008

  • Generate Barcodes in Microsoft Reporting Service 2008
  • Drag and drop Barcode Custom Report Item to your report layer pages
  • High quality bar code images in GIF, PNG, JPEG & BITMAP
  • Completely developed in C#.NET 2008
  • Mature barcode generating components for Reporting Service using .NET Barcode Generator component
.NET Barcode for Reporting Service is the most flexible and powerful .NET Component (.NET dll Class Library) which lets you to easily add advanced barcoding generation in your Microsoft SQL Server Reporting Services projects. Note that, SQL Server 2008 R2 Express version does not support Custom Report Items (CRI). Therefore, our Reporting Service Barcode Libaray DLLs are not available for this SQL Server version.
To generate barcodes in SQL Server Reporting Services 2005, please go to Barcode Generator for Reporting Services 2005 Guide.
.NET Reporting Service 2008 Barcode Generator - Deploy Barcode Controls
Top
  • Open directory "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\"

    Copy "OnBarcode.Barcode.RS2008CRI.dll" and "OnBarcode.Barcode.RS2008.dll" to the folder

  • Open directory "\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\"

    Copy "OnBarcode.Barcode.RS2008CRI.dll" to the folder
.NET Reporting Service 2008 Barcode Generator - Config Environments
Top
  • In file: "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\rsreportdesigner.config"
  • <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          	 Type="OnBarcode.Barcode.RS2008CRI.LinearReportCRI, OnBarcode.Barcode.RS2008CRI" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          	 Type="OnBarcode.Barcode.RS2008CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2008CRI" />
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2008CRI" />
          <ReportItem Name="QRCodeBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2008CRI" />
        </ReportItems>
        <ReportItemDesigner>
          <ReportItem Name="LinearBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008.LinearReport, OnBarcode.Barcode.RS2008" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008.DataMatrixReport, OnBarcode.Barcode.RS2008" />
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008.PDF417Report, OnBarcode.Barcode.RS2008" />
          <ReportItem Name="QRCodeBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008.QRCodeReport, OnBarcode.Barcode.RS2008" />
        </ReportItemDesigner>
      </Extensions>
    </Configuration>
    
  • In file: "\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config"
  • <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.LinearReportCRI, OnBarcode.Barcode.RS2008CRI"/>
          <ReportItem Name="DataMatrixBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2008CRI"/>
          <ReportItem Name="PDF417BarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2008CRI"/>
          <ReportItem Name="QRCodeBarcodeControl" 
          	  Type="OnBarcode.Barcode.RS2008CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2008CRI"/>
        </ReportItems>
      </Extensions>
    </Configuration>
    
  • In file: "\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config"
  • <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 OnBarcode.Barcode.RS2008CRI.dll
                         Full Trust permission. ">
                  <IMembershipCondition
                    class="UrlMembershipCondition"
                    version="1"
                    Url="C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\
                         ReportServer\bin\OnBarcode.Barcode.RS2008CRI.dll" />
                </CodeGroup>
    
                ...
    
              </CodeGroup>
            </PolicyLevel>
          </policy>
        </security>
      </mscorlib>
    </configuration>
    
How to generate barcodes in Reporting Service 2008 reports in Visual Studio 2008 and later version?
Top
  1. Start Visual Studio 2008, 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 select "AdventureWorks" as our data source. Then click Next to proceed.



  3. Now please 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", 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.RS2008.dll" from "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\"
    6. Check the 4 barcode components for reporting service "DataMatrixBarcodeControl", "LinearBarcodeControl", "PDF417BarcodeControl", "QRCodeBarcodeControl", and click OK.
    7. Now you can find 4 barcode components added 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 report with barcodes generated.

Reporting Service 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 high quality .NET Imaging SDK, Java Imaging Library, and their easy and simple documents, like imaging in C#, imaging in VB.NET, PDF in C# and PDF in VB.NET.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.