Barcode Creation in Reporting Service 2008 Guide

To generate high quality barcode images in SQL Server Reporting Service 2008 with barcode generator SDK

Linear & 2D Barcode Generating in SQL Server Reporting Service 2008

• Generate Barcodes in Microsoft Reporting Service 2008
  
• Drag and drop Barcode Custom Report Item to your report layer pages
• High quality BarCode 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 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.
3. Select Data Source. We are using "AdventureWorks" as our data source. Click Next.




4. Create Query string. Copy "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer" to the Query string input box.




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




10. Now you need 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".
7. Click OK
8. Now you can find 4 barcode components in your Report Item Toolbox.



11. 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. Keyin "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"





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

Reporting Service Barcode Generator Supported Barcode Types

Top

Barcode Library for Reporting Service - Barcode Image Generation

• 1D / Linear Barcodes in SQL Server Reporting Service:

Codabar	Code 11	Code 2 of 5 (Industrial 2 of 5)	Code 39	Code 93
Code 128	EAN 8, Sup 2/5	EAN 13, Sup 2/5	GS1 128 (UCC/EAN128)	GS1 DataBar
Identcode	Intelligent Mail(OneCode)	Interleaved 2 of 5	ISBN, Sup 2/5	ISSN, Sup 2/5
ITF-14	Leitcode	MSI Plessey	PLANET	POSTNET
RM4SCC	UPC-A, Sup 2/5	UPC-E, Sup 2/5

• 2D / Matrix Barcodes in SQL Server Reporting Service: Data Matrix, PDF-417, QR-Code , Micro PDF-417, Micro QR Code