How to generate Barcode in Microsoft Reporting Service 2005

• BarcodeLib.Barcode.dll, BarcodeLib.Barcode.ReportingService.dll
• Microsoft .NET Framework 2.0 (or later)
• Microsoft Reporting Services 2005 (or later)

We have provided one demo data file named "BarcodeDemoData.mdb" in our trial package. In the following steps, we will config ODBC driver for that data file.

1. Open "Control Panel". Go to "Start", and click menu "Control Panel".
2. Click "Administrative Tools".
3. Click "Data Sources (ODBC)".
4. In "ODBC Data Source Administrator", click tab "System DSN".
5. Click button "Add..." on the right side of the form. view image
6. In "Create New Data Source" form, select "Driver do Microsoft Access (*.mdb)", and click "Finish" button. view image
7. In "ODBC Microsoft Access Setup" form, fill "Data Source Name" as "BarcodeDataSource", then click "Select..." button. view image
8. In "Select Database" form, go to your downloaded package, and select "BarcodeDemoData.mdb" file, and click "OK" button. view image
9. In "ODBC Microsoft Access Setup" form, click "OK" button.
10. Now you can find new entry in "System Data Sources: " section. view image
    click "OK" button to close it.

1. Copy BarcodeLib.Barcode.dll, BarcodeLib.Barcode.ReportingService.dll to Visual Studio private assemblies directory (by default C:\\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies)
2. Copy BarcodeLib.Barcode.dll, BarcodeLib.Barcode.ReportingService.dll to Microsoft SQL Server Reporting Services bin directory (by default C:\\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin)
3. Edit rsreportserver.config file under "C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer"
   <Configuration>
   ...
   <Extensions>
   ...
   <ReportItems>
   <ReportItem Name="LinearBarcodeControl" Type="BarcodeLib.Barcode.Linear.LinearReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="DataMatrixBarcodeControl" Type="BarcodeLib.Barcode.DataMatrix.DataMatrixReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="PDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.PDF417ReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="MicroPDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.MicroPDF417ReportItem, BarcodeLib.Barcode.ReportingService" />
   </ReportItems>
   </Extensions>
   </Configuration>
   
4. Edit rssrvpolicy.config under the same folder with rsreportserver.config
   <CodeGroup class="UnionCodeGroup"
   version="1"
   PermissionSetName="FullTrust"
   Description="This code group grants BarcodeLib.Barcode.dll FullTrust permission. ">
   <IMembershipCondition
   class="UrlMembershipCondition"
   version="1"
   Url="C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\BarcodeLib.Barcode.ReportingService.dll" />
   </CodeGroup>
   
5. Edit rsreportdesigner.config under "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"
   
   <ReportItemDesigner>
   <ReportItem Name="LinearBarcodeControl" Type="BarcodeLib.Barcode.Linear.LinearReportDesigner, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="DataMatrixBarcodeControl" Type="BarcodeLib.Barcode.DataMatrix.DataMatrixReportDesigner, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="PDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.PDF417ReportDesigner, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="MicroPDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.MicroPDF417ReportDesigner, BarcodeLib.Barcode.ReportingService" />
   </ReportItemDesigner>
   
   <ReportItems>
   <ReportItem Name="LinearBarcodeControl" Type="BarcodeLib.Barcode.Linear.LinearReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="DataMatrixBarcodeControl" Type="BarcodeLib.Barcode.DataMatrix.DataMatrixReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="PDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.PDF417ReportItem, BarcodeLib.Barcode.ReportingService" />
   <ReportItem Name="MicroPDF417BarcodeControl" Type="BarcodeLib.Barcode.PDF417.MicroPDF417ReportItem, BarcodeLib.Barcode.ReportingService" />
   </ReportItems>
   

1. Create a report: Select File | New | Project from the Visual Studio .NET 2005 IDE menu. In the New Project dialog, highlight Business Intelligence Projects in the Project Types box and Report Project Wizard in the Templates box. Name the sample report appropriately in the Name box. Click OK. view image
2. In "Report Wizard" form, keyin name as "BarcodeDemoData", select type as "ODBC", and click "Edit.." button. view image
3. In "Connection Properties" form, select "use user or system data source name:" as "BarcodeDataSource", and click "OK" button. view image
4. In "Report Wizard" form, click "Next" button.
5. Type in "SELECT * FROM Customer;" in "Query String:" field. Click "Next". view image
6. Select report type form, select "Tabular" as default. Click "Finish".
7. In report designer panel, add a new column "Barcode" to the table, by right click column "Customer" header, and select "Insert Column to the right" menu. view image
8. for the new column "Barcode", set name as "Barcode". Drop "LinearBarcodeControl" to the data section. view image
9. Set "BarcodeData" property to "=Fields!CustomerId.Value". view image
10. You can preview the report by click "Preview" tab. view image