How to use Barcode in Reporting Services 2005 report's Code section - Product List Sa

Technologies used
- Neodynamic Barcode Professional 3.0 for Reporting Services or greater
- Microsoft .NET Framework 2.0 or greater
- Microsoft Visual Studio 2005 or SQL Server Business Intelligence Development Studio
- Microsoft SQL Server 2005 Express, Workgroup, Standard or Enterprise Edition
- Microsoft SQL Server 2005 Reporting Services

In the following walkthrough we'll create a Report Server Project which features barcode images by using Barcode Professional, Visual Studio 2005 or SQL Server Business Intelligence Development Studio, and Reporting Services 2005.

In this sample we'll create a Product List RDL report by using Microsoft's AdventureWorks database sample.

Follow these steps:
1. Open Visual Studio 2005 or SQL Server Business Intelligence Development Studio and create a new Report Server Project
2. Add a new Data Source pointing to the AventureWorks database
3. Add a new Report item, name it to ProductList.rdlc, and enter the following SQL Statement:

SELECT ProductID, Name, ProductModel, CultureID FROM Production.vProductAndDescription WHERE (CultureID = N'en')

as is shown in the below figure.
http://www.neodynamic.com/Support/FA...re01_small.png

4. Select a Tabular type report and add the fields ProductID, Name, and ProductModel into the Report's Detail section. The report should look like the following figure.
http://www.neodynamic.com/Support/FA...re02_small.png

5. In this sample we'll use the Code 39 Barcode Symbology, but remember that you can use ANY Barcode Symbology built-in Barcode Professional.

Follow these steps:
5.1. Ensure to install Barcode Professional for Reporting Services.
5.2. In Visual Studio and with the report opened at design-time, add a reference to the Barcode Professional assembly (Neodynamic.ReportingServices.Barcode.dll) going to Report > Report properties... Add the reference as is shown in the following figure:

Notice that the assembly version could be different from the image depending on the Barcode Professional for Reporting Services version installed on your machine.

http://www.neodynamic.com/Support/FA...re03_small.png

We'll need to create an instance of Barcode Professional to use it then in a custom function on the Report's Code section. To do this, add a new entry in the Classes grid as is shown in the following figure. Notice that the instance will be named objBarcode and that the full reference to the class is Neodynamic.ReportingServices.Barcode

http://www.neodynamic.com/Support/FA...re04_small.png

5.3. Finally, we need to create a VB.NET function which will be invoked to get the appropriate Code 39 barcode image by using the Barcode Professional instance created in the previous step. In the Code tab write the following code:

Public Function GetBarcode(ByVal code As String) As Byte()
'Set the value to encode
objBarcode.Code = code
'Set the Code 39 Barcode Symbology
objBarcode.Symbology = _
Neodynamic.ReportingServices.Symbology.Code39
Set the Bar's height to 0.25 in
objBarcode.BarHeight = 0.25F
'Disable checksum
objBarcode.AddChecksum = False
'Enable AutoSize
objBarcode.AutoSize = True
'Generate the barcode image
Return objBarcode.GetBarcodeImage()
End Function


This VB.NET function called GetBarcode requires a code parameter. This value will be specified with some fields of the DataSet in the Data Source report. And as you can see in this function you can set any property of Barcode Professional.

http://www.neodynamic.com/Support/FA...re05_small.png

Click OK to close the dialog box.

6. Now we'll design the Product List report layout. In the Layout tab of the report drag & drop an Image control under Product ID column as is shown in the following figure:

http://www.neodynamic.com/Support/FA...re06_small.png

expression:

http://www.neodynamic.com/Support/FA...re07_small.png

7. Click on Preview tab and you'll get something like the following:

http://www.neodynamic.com/Support/FA...re08_small.png

8. Deployment
Please, refer to the product help documentation regarding this topic.

9. That's it. The Report Server is ready to deliver reports featuring barcode images.

http://www.neodynamic.com/Support/FA...re09_small.png

Links:
This Demo
More Demos
Download Barcode Professional for Reporting Services
More Information about Neodynamic Barcode Professional for Reporting Services

Neodynamic
.NET Components & Controls
http://www.neodynamic.com
http://www.barcode-for-reporting-services.com