Cart
Support
Contact Us
FAQ
Customer Login
User Manuals
ActiveX Control
Code 128 Fonts
UPC EAN Fonts
Code 39 Fonts
Interleaved 2 of 5 Fonts
OnLabel
Video Tutorials
ActiveX Control
Barcode Fonts
OnLabel
Buy Now
Specials
BarCodeWiz Bundle Special
Barcode Control and Add-ins
ActiveX Control
Barcode Fonts and Add-ins
Code 128
UPC EAN
Code 39
Interleaved 2 of 5
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Upgrades and Renewals
Download Trial
Barcode Control and Add-in
ActiveX Control Trial
Barcode Fonts and Add-ins
Code 128 Trial
UPC EAN Trial
Code 39 Trial
Interleaved 2 of 5 Trial
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Products
Barcode Software Comparison
Barcode Control and Add-in
ActiveX Control
Barcode Fonts and Add-ins
Code 128
UPC EAN
Code 39
Interleaved 2 of 5
Barcode Label Software
OnLabel
Barcode Controls for .NET
Barcode Control for ASP.NET
Barcode Control for Windows Forms
Home
UPC EAN Barcode Fonts
UPC EAN Barcodes in SQL Server Reporting Services (SSRS)
UPC EAN Barcodes in SQL Server Reporting Services (SSRS)
Download Trial
Buy Now
Barcodes in Microsoft Excel
Install UPC EAN Fonts Toolbar in Excel
Convert selected cells to barcodes
Create a sheet of sequential barcode labels
Use spreadsheet formulas to create barcodes
Create barcodes with VBA and macros
Barcodes in Microsoft Word
Install UPC EAN Fonts Toolbar in Word
Convert selected text to barcode
Create barcode labels with Mail Merge
Print a sheet of barcode labels
Use macros and VBA to create barcodes
Barcodes in Microsoft Access
Create Barcodes in MS Access
Barcode Labels Wizard in MS Access
Barcodes in Crystal Reports
Install UPC EAN Fonts User Function Library (UFL)
UPC EAN Barcodes in Crystal Reports
More Tutorials
UPC EAN Barcodes in SQL Server Reporting Services (SSRS)
Barcodes in VB.NET
Barcodes with C#
UPC EAN Barcodes in MS Publisher Mail Merge
How to create barcodes in SSRS
BarCodeWiz UPC EAN Fonts can be used to create barcodes in SSRS. Follow the steps below to add barcodes to your own report.
Step 1. Create a new report
Click on
File
>
New
>
Blank Report
Step 2. Connect your Data Source
In this example, we are using a simple 3 column items data set.
Step 3 Add BarCodeWiz Code to the Report
Right-Click
on the blue report background and select
Report Properties
Locate the text file containing the code. The default location of the text file is:
Documents\BarCodeWiz Examples\UPC EAN Barcode Fonts\Report Builder\code.txt
Copy the contents of the file into the
Custom Code
window of
Report Properties
and click on the
Refrences
tab.
Step 4. Add a Reference to System.Drawing.dll
Under
Report Properties
, click on
References
>
Add
Locate
System.Drawing.dll
. Default windows location is under:
C:\Windows\Microsoft.NET\Framework\v2.0.50727\
Step 5. Insert Table into the report
Under the
Insert
tab in the
Data Regions
section, click on
Table
>
Insert Table
Click and drag to desired dimensions
Drag non-barcode dataset items into the
header
columns on the table.
In this example, we used
item_name
and
item_price
for the first two columns.
Then, under the
Insert
tab in the
Report Items
section, insert an
Image
into the table cell.
Note: the header text for
item barcode
was manually typed in on the third column in our example.
Once the image control is inserted, right-click and select
Image Properties
.
In the General tab of
Image Properties
:
Select
Database
as the image source.
Select
image/png
as the MIME type
Under
Use this field
, select the
Fx
button and enter the following expression:
=Code.EAN13Bytes(Fields!item_barcode.Value, 1)
Click OK.
Step 6. Finalize and generate report
Under the
Home
tab, in the
Views
section click
Run
to generate the report.
The final result
UPC EAN Fonts Functions in SSRS
UPCABytes(barcode as String, height as Integer)
Encodes the barcode in UPC-A format.
The function parameters are:
barcode
: String value with the barcode data to encode. Must be 11 or 12 digits. Enter 11 digits to have the check digit added automatically. Also accepts 13, 14, 15, or 17 digits for +2 and +5 Add-on
height
: Integer value indicating which version of the font height should be selected. Valid values are from 1 to 6.
UPCEBytes(barcode as String, height as Integer, showText as Boolean)
Encodes the barcode in UPC-E format.
The function parameters are:
barcode
: String value with the barcode data to encode. Must be 7 or 8 digits. Enter 7 digits to have the check digit added automatically. Also accepts 9,10, 12, or 13 digits for +2 and +5 Add-on
height
: Integer value indicating which version of the font height should be selected. Valid values are from 1 to 6.
EAN13Bytes(barcode as String, height as Integer, showText as Boolean)
Encodes the barcode in EAN-13 format.
The function parameters are:
barcode
: String value with the barcode data to encode. Must be 12 or 13 digits. Enter 12 digits to have the check digit added automatically. Also accepts 14, 15, 17, or 18 digits for +2 and +5 Add-on
height
: Integer value indicating which version of the font height should be selected. Valid values are from 1 to 6.
EAN8Bytes(barcode as String, height as Integer, showText as Boolean)
Encodes the barcode in EAN-8 format.
The function parameters are:
barcode
: String value with the barcode data to encode. Must be 7 or 8 digits. Enter 7 digits to have the check digit added automatically.
height
: Integer value indicating which version of the font height should be selected. Valid values are from 1 to 6.
Copyright © 2000-2019 BarCodeWiz, Inc.
|
Privacy Policy