Reporting Service 2005 Developer Guide & Tutorial
Note that, 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
-
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 maybe MSSQL.1, MSSQL.2, or MSSQL.4.
Copy "OnBarcode.Barcode.RS2005CRI.dll" to the folder.
Config Environments
-
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 maybe 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 maybe 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 Start?

Top
Below steps explain how to generate barcodes in Reporting Service 2005 reports in Visual Studio 2005.
-
Start Visual Studio 2005, 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 report name
-
Click "Next" in Report Wizard dialog.
-
When a window pops up to select a data source, we are using "AdventureWorks" as our data source. After that please click Next to proceed.
-
Create Query string by copying "SELECT CustomerID, TerritoryID, AccountNumber FROM Sales.Customer" to the Query string input box.
-
Select "Tabular" as report type.
-
Use the default settings in "Design the Table" Dialog, and click Next.
-
Use the default settings in "Choose the Table Style" Dialog, and click Next.
-
Use the default settings in "Choose the Deployment Location" Dialog, and click Next.
-
Name the report "Barcode in Reporting Service 2005" and cick Finish.
-
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.RS2005.dll" from "\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\"
- Check the 4 barcode components for reporting service "DataMatrixBarcodeControl", "LinearBarcodeControl", "PDF417BarcodeControl", "QRCodeBarcodeControl".
- Click OK
- Now you can find 4 barcode components in your Report Item Toolbox.
-
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"
- Key in "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"
-
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
- 2D / Matrix Barcodes:
- 1D / Linear Barcodes:
Support supplement 2, 5 digits for UPC/EAN barcodes