Create a List Report in SSRS

In this article, we will show you how to Create a List Report in SSRS. The SSRS List reports are helpful to place the Column values, along with the charts or corresponding images. So, here we will show you the step by step approach to create a List Report in SSRS with an example.

To demonstrate the SSRS List report, We are going to use the below shown Data Set. Please refer to Embedded Data Source and Dataset articles to understand creating an Embedded Data Source and Data set that we used for this SSRS report.

Create a List Report in SSRS 1

and the Custom SQL query that we used in the above Data set is:

-- Create List Report in SSRS
USE [AdventureWorksDW2014]
GO
SELECT [FirstName] + ' ' + [LastName] AS [FullName]
      ,[EmailAddress]
      ,[Gender]
      ,[Title]
      ,SUM(FACT.SalesAmount) AS SalesAmount
      ,SUM(FACT.TotalProductCost) AS ProductCost
      ,[EmployeePhoto]
  FROM [DimEmployee] AS EMP
  INNER JOIN [FactResellerSales] AS FACT ON
  EMP.EmployeeKey = FACT.EmployeeKey
  GROUP BY [FirstName]
      ,[LastName]
      ,[EmailAddress]
      ,[Gender]
      ,[Title]
      ,[EmployeePhoto]

Data written by the above query is:

Create a List Report in SSRS 0

Create a List Report in SSRS

To demonstrate the steps involved to Create a List Report in SSRS, We are going to use the previously generated report that we shown below.

Please refer to Create a New Report, and Add headers and Footer to SSRS Report article for adding Page headers.

Create a List Report in SSRS 2

To add the List Item to report designer, please right-click on the report area, and select the Insert, and then List option from the context menu.

Create a List Report in SSRS 3

Once you select the List option from the context menu, a new List Item will add to the SSRS report area.

Create a List Report in SSRS 4

For the demonstration purpose, let me drag and drop the [Full Name] column from the ListDS to the List area.

Create a List Report in SSRS 5

Next, we will add one more Text box inside the SSRS List area. And to do so, right-click on the List area, and select the Insert, and then Text Box option from the context menu.

Create a List Report in SSRS 6

As you can see, we added the custom Text called (Employee Name] to the newly added text box.

Create a List Report in SSRS 7

Use the above-specified approach to add custom text for Email ID and the Designation. Next, drag and drop Email Address, and the Title columns from the ListDs to List area.

Create a List Report in SSRS 8

Within the SSRS List Report preview, you can see the Custom text and the corresponding column values.

Create a List Report in SSRS 9

SSRS List area is nothing but a rectangle. If you right-click on the list area will open the context menu. Please select the Rectangle Properties.. option to alter the existing properties of the list area. Please refer Add Rectangle to SSRS Report article to understand the rectangle format options.

Create a List Report in SSRS 10

Let me show you the SSRS List Report preview. The list is displaying the items with a beautiful font because we formatted all the textboxes inside the list area.

I suggest you to refer Formatting Text Box article to understand the steps involved in formatting the text boxes.

Create a List Report in SSRS 11

Let me add the Image to the List area. See, we are assigning the Employee Photo column as the image source. I suggest you refer to Display Image in SSRS Report article to understand the steps involved in adding an image to report.

Create a List Report in SSRS 12

Click OK to close the properties window, and adjust the text box length, and widths

Create a List Report in SSRS 13

Click on the preview tab to see the SSRS List report preview.

Create a List Report in SSRS 14