Reporting Service 2012 Developer Guide & Tutorial




    With an easy-to-use design purpose, our software doesn't need any activation code or registrion code. And ONBARCODE grants to you to use this evaluation
    package, on one computer, for Evaluation purposes only within 30 days. And a red text (watermark) will appear on the generated barcode(s) randomly.

    Once you ordered any license of the product, we will email you OnBarcode.BarcodeGenerator.ReportingService.zip production version as soon as possible.

    We also provide
Deploy Controls & Config Environments
Top

Deploy Barcode Controls

  1. Open directory "\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\".

    Copy "OnBarcode.Barcode.RS2012CRI.dll" and "OnBarcode.Barcode.RS2012.dll" to the folder.

  2. Open directory "\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin\".

    Copy "OnBarcode.Barcode.RS2012CRI.dll" to the folder.

Config Environments

  1. In file: "\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\rsreportdesigner.config"
    <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.LinearReportCRI, OnBarcode.Barcode.RS2012CRI" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2012CRI" />
          <ReportItem Name="PDF417BarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2012CRI" />
          <ReportItem Name="QRCodeBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2012CRI" />
        </ReportItems>
        <ReportItemDesigner>
          <ReportItem Name="LinearBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012.LinearReport, OnBarcode.Barcode.RS2012" />
          <ReportItem Name="DataMatrixBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012.DataMatrixReport, OnBarcode.Barcode.RS2012" />
          <ReportItem Name="PDF417BarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012.PDF417Report, OnBarcode.Barcode.RS2012" />
          <ReportItem Name="QRCodeBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012.QRCodeReport, OnBarcode.Barcode.RS2012" />
        </ReportItemDesigner>
      </Extensions>
    </Configuration>
    
  2. In file: "\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config"
    <Configuration>
      <Extensions>
    
        ...
    
        <ReportItems>
          <ReportItem Name="LinearBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.LinearReportCRI, OnBarcode.Barcode.RS2012CRI"/>
          <ReportItem Name="DataMatrixBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.DataMatrixReportCRI, OnBarcode.Barcode.RS2012CRI"/>
          <ReportItem Name="PDF417BarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.PDF417ReportCRI, OnBarcode.Barcode.RS2012CRI"/>
          <ReportItem Name="QRCodeBarcodeControl" 
          		Type="OnBarcode.Barcode.RS2012CRI.QRCodeReportCRI, OnBarcode.Barcode.RS2012CRI"/>
        </ReportItems>
      </Extensions>
    </Configuration>
    
  3. In file: "\Program Files\Microsoft SQL Server\MSRS11.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.RS2012CRI.dll Full Trust permission. ">
                  <IMembershipCondition
                      class="UrlMembershipCondition"
                      version="1"
                      Url="C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\
                      		ReportServer\bin\OnBarcode.Barcode.RS2012CRI.dll" />
                </CodeGroup>
    
                ...
    
              </CodeGroup>
            </PolicyLevel>
          </policy>
        </security>
      </mscorlib>
    </configuration>
    
    
How to Start?
Top

Below steps explain how to generate barcodes in Reporting Service 2012 reports in Visual Studio 2010.

  1. Start Visual Studio 2010, and create a new project. In "New Project" dialog,
    • Select "Business Intelligence Projects" as project type
    • Select "Report Server Project Wizard" as template
    • Use the default name "Report Project1" as project name

  2. Click "Next" in Report Wizard dialog.

  3. When a window pops up to select Data Source, we are using "AdventureWorks" as our data source. After that please click Next to proceed.


  4. Create Query string by copying "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" and click Finish.

  10. Now you need to add OnBarcode Reporting Service Barcode CRI to your Report Item Toolbox.
    • Right click "Report Items"
    • Click "Choose Items..."
    • Select tab ".NET Framework Components"
    • Click "Browse..." button
    • Select "OnBarcode.Barcode.RS2012.dll" from "\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\"
    • Check the 8 barcode components for reporting service
      "DataMatrixBarcodeControl",
      "DataMatrixRS",
      "LinearBarcodeControl",
      "LinearRS",
      "PDF417BarcodeControl",
      "PDF417RS",
      "QRCodeBarcodeControl",
      "QRCodeRS".
    • Click OK
    • 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.
    • Right click the table in the report, select "Insert Column to the Right"
    • Keyin "Barcode" as column header
    • Drag "LinearBarcodeControl" to the Column "Barcode"
    • Select linear barcode, go to Property window and change property "BarcodeData" to "=Fields!AccountNumber.Value"



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


Barcode Setting in Reporting Service Barcode Generator
Top

Barcode for Reporting Service - Bar Code Types Generation



OnBarcode is a market-leading provider of barcode 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 high quality tutorials and guides for various linear, 2d barcode information, such as C# Barcode, QR Code C#, QR Code VB.NET, QR Code ASP.NET, QR Code .NET. Combined with its major reporting barcode tools as well as its Microsoft Office (Excel & Word) barcode add-on, barcode fonts, OnBarcode offers comprehensive barcode solution for building business applications. OnBarcode products help thousands of companies be more productive and deliver high quality bar code automation products under budget and on time.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.