In this article I will explain step by step with an example, how to display binary images stored in database in Crystal Report in ASP.Net using C# and VB.Net.
The Binary Data field will be displayed using Photo field in Crystal Reports and using an Image handler, the Images from Database Table will be fetched and displayed in Crystal Report.
Note: By default Visual Studio does not include Crystal Reports hence you need to download and install the Crystal Reports software for Visual Studio.
Please refer the following link and download the appropriate version of Crystal Reports for your version of Visual Studio.
Here I am making use of Microsoft’s Northwind Database. You can download it from here.
Note: The Employees Table of Northwind database already has Binary Images stored in it.
1. Add Typed DataSet to the ASP.Net Website
Since I am using disconnected Crystal Reports we will make use of Typed DataSet to populate the Crystal Reports with data from database.
2. Adding DataTable to the Typed DataSet
Our next step would be to add a DataTable to the Typed DataSet.
3. Adding Columns or fields to DataTable
In the DataTable we need to specify the column names that we want to display in the Crystal Report.
Note: The Column Names of the DataTable must exactly match with the actual Database Table column names.
By default all the columns are of String data type but since the Image is stored in binary format for the Photo column we need to change the data type to Byte Array using the properties window as show below.
4. Add Crystal Report to the ASP.Net Website
Now you will need to add a Crystal Report to the ASP.Net Application. You can give it name as per your choice.
As soon as you click OK you get the following dialog. You must select Using the Report Wizard option.
Once you press OK in the above dialog, the Report Wizard starts and you get the following dialog where you need to choose the type of Database connection for your Crystal Report. Since we are using DataSet you will need to choose the Employees DataSet.
Next the Wizard will ask for the Columns or Fields from the Employees DataSet you need to display on the Crystal Reports. You can choose either all or specific fields as per you choice.
Note: There are more steps in the Wizards but those are Optional hence are not included in this article.
Once you click Finish button, your Crystal Report should look as below. Sometimes the Photo might not be shown thus in such case you can Drag and Drop it from the left panel.
The following HTML Markup consists of a CrystalReportViewer control.
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<form id="form1" runat="server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />
You will need to import the following namespaces.
Populating the Crystal Report from Database
Inside the Page Load event, the Crystal Reports is populated with the records from database.
protected void Page_Load(object sender, EventArgs e)
ReportDocument crystalReport = new ReportDocument();
Employees dsEmployees = GetData("select * from employees");
CrystalReportViewer1.ReportSource = crystalReport;
private Employees GetData(string query)
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
using (SqlDataAdapter sda = new SqlDataAdapter())
cmd.Connection = con;
sda.SelectCommand = cmd;
using (Employees dsEmployees = new Employees())
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim crystalReport As New ReportDocument()
Dim dsEmployees As Employees = GetData("select * from employees")
CrystalReportViewer1.ReportSource = crystalReport
Private Function GetData(query As String) As Employees
Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Dim cmd As New SqlCommand(query)
Using con As New SqlConnection(conString)
Using sda As New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
Using dsEmployees As New Employees()
Adding the Crystal Reports Image Handler in Web.Config
This is the most important part and without it you will not see the Images in Crystal Report. You need to add the following in the httpHandlers section of Web.Config.
<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />