QR Code Barcodes in RDLC Reports
Generating Reports with QR Code 2D Barcodes in Visual Studio
- This tutorial shows how you can add QR Code barcodes to Visual Studio RDLC Reports.
- Watch the video or follow the steps below.
Before You Begin...
- Make sure you've got Microsoft RDLC Report Designer installed.
- (1) To install it, go to Extensions / Manage Extensions
- (2) Type RDLC in the search field
- (3) Click Download
- Proceed with installation.
- Check if you have Microsoft.SqlServer.Types installed.
- Otherwise, go to Project / Manage NuGet Packages...
- On the NuGet window search for Microsoft.SqlServer.Types
- Click on Install and follow the installation wizard
Step 1. Create a new Project
- In the main Visual Studio window, select Create a new Project
- Type Reports and select Reports Application (in our case C# project)
- Name your project
- Select the Framework that you plan to use
- Click on Create
Step 2. Bind a Data Source
- Select the Data Source Type that you would like to use in your reports (in our case it will be Access Database )
- click on Next
- Select Dataset for the database model and click Next
- Click on New Connection...
- On the Choose Data Source screen, select Microsoft Access Database File and click on Continue
- On the Add Connection screen click on Browse...
- On the Select Microsoft Access Database File screen, browse to the folder Documents\BarCodeWiz Examples\BarCodeWiz QR Code Fonts\Access and select QrCode_Access_Example.mdb
- Click on Open
- On the Add Connection screen, click OK
- Select Tables to use in the Report
- click on Finish
- Click on Next on the next screen (Dataset Properties)
- Arrange fields for the report.
- In our case, we have placed all the fields in the Values section without summarizing.
- Click on Next on the next screen (Choose the layout).
- Click on Finish on the screen named Preview.
Step 3. Setting up the Source of the Report's Definition
- Double - click Form1.cs in Solution Explorer
- Configure Data Sources:
- Bind your Report with Form1
- Click on the tiny triangle just below the Close button
- Select MyQRCodeReport.report1.rdlc
- Click on Choose Data Sources
- Expand available sources and select the one you configured earlier.
- In our case - Items
Step 4. Changing the Project Platform to x64
- If you Start your Project now, you would receive an error saying there is no OLEDB driver for ACCESS files on the machine.
- To prevent that, we have to switch the debug to x64 processors.
- Go to Configuration Manager...
- (1) In Configuration Manager window, select New from the list under Platform
- (2) In New Project Platform, select x64
- Click OK and Close
Step 5. Configure Report Properties
- Right-click on the empty area of Report1.rdlc and select Report Properties
- In the Report Properties window, select the References section.
- 1) Click Add to add the assembly
- 2) Type: BarCodeWizFonts.QrCode
- 3) Click Add to add a class instance
- 4) Type BarCodeWizFonts.QrCode.QrCodeFonts for class name and MyQRCode for instance name.
Step 6. Insert a new column with data to encode
- Right-click on the last column's header and select Insert Column - Right.
- In the new column, click in the upper-right corner and select the column with data you wish to encode (in our case - item_name).
Step 7. Edit the Expression
- Right-click on the column with the data to encode (item_name) and select Expression
- Edit the Expression:
- =Code.MyQrCode.Encode( Fields!item_name.Value)
- Click OK
Step 8. Add reference to BarCodeWizFonts.QrCode.dll
- In Solution Explorer right-click on References
- Select Add Reference...
- In Reference Manager click on Browse.
- In the Select the files to reference window, browse to folder Program Files\BarCodeWiz\BarCodeWiz QR Code Fonts\DotNet\net20 and add the file BarCodeWizFonts.QrCode.dll
- Click OK in the Reference Manager window.
- Test your Report
- Click Start Without Debugging or press CTRL + F5
- You should see a report similar to the screenshot
Step 9. Set the font
- Change the font to BCW_QR
- Set point size to 6
The Report is ready!
- Click Start Without Debugging or press CTRL + F5 to preview it
