Pro SQL Server 2012 Reporting Services

The completed report for the Chart object is in the Pro_SSRS project and is called Chart.rdl.

Implementing an Image

Having images in a report can give it a polished look while extending its value as a resource. Fortunately,
SSRS includes an image tool that can add images from a variety of locations and supports many standard
image formats. Our health care application stores many images in a SQL Server database as Binary Large
Objects (BLOBs), as part of a patient electronic medical record (EMR). You can load any type of image
into the database and associate it with the patient using a front-end image retrieval application. Once
the image is in the database and tagged to a patient’s identification number, which is a field in the
database, you can use SSRS to display that image in a report. For this sample, you will continue with the
theme of famous author patients and add their images to a simple report. The starting-point report for
the Image report object is called Image Start.rdl. Since much of the report is constructed using objects
you have already used, the starting point is already laid out with these objects included. The dataset that
is used for this report includes demographic information for patients who have their photographs stored
in a database table called DocumentImage in the Pro_SSRS database. You can use the predefined
dataset, called Get_Image, for the Image Start.rdl report, which simply returns patient demographic
information for three patients along with their photos using a text query type as shown in Figure 5-5.