SSRS – Using List Item

Introduction

Again I have a request to give demo of LIST in SSRS. We can play with SSRS to build some wanders.
To provide a simple demo we are just made a SSRS report by using LIST, TEXT BOX and TABLE.

This is only a demo. Nothing related to production.

How We Made that

Step – 1 [ Create Base Table and Insert Records ]

CREATE TABLE [dbo].[tbl_SchoolDetails]

  (

       IDNo                 INT                  NOT NULL IDENTITY PRIMARY KEY,

       StateName            VARCHAR(50)          NOT NULL,

       SchoolName           VARCHAR(50)          NOT NULL,

       StudentID            INT                  NOT NULL,

       StudentName          VARCHAR(50)          NOT NULL,

       StudentSub           VARCHAR(50)          NOT NULL,

       StudentMarks         INT                  NOT NULL

  )

INSERT INTO [dbo].[tbl_SchoolDetails]

(StateName, SchoolName, StudentID, StudentName, StudentSub, StudentMarks)

VALUES

('Tripura', 'Bothjung HS School', 1, 'Joydeep Das', 'English', 30),

('Tripura', 'Bothjung HS School', 1, 'Joydeep Das', 'Franch', 90),

('Tripura', 'Bothjung HS School', 1, 'Joydeep Das', 'Math', 50),

('Tripura', 'Bothjung HS School', 2, 'Tapan Bhoumik', 'English', 70),

('Tripura', 'Bothjung HS School', 2, 'Tapan Bhoumik', 'Franch', 30),

('Tripura', 'Bothjung HS School', 2, 'Tapan Bhoumik', 'Math', 80),

('Tripura', 'Pragati School', 1, 'Haripad Roy', 'English', 70),

('Tripura', 'Pragati School', 1, 'Haripad Roy', 'Franch', 90),

('Tripura', 'Pragati School', 1, 'Haripad Roy', 'Math', 90),

('Tripura', 'Pragati School', 2, 'Tinku Saha', 'English', 20),

('Tripura', 'Pragati School', 2, 'Tinku Saha', 'Franch', 80),

('Tripura', 'Pragati School', 2, 'Tinku Saha', 'Math', 10),

('Assam', 'Gwahati Girls', 1, 'Tuinkel Khanna', 'English', 10),

('Assam', 'Gwahati Girls', 1, 'Tuinkel Khanna', 'Franch', 40),

('Assam', 'Gwahati Girls', 1, 'Tuinkel Khanna', 'Math', 20),

('Assam', 'Gwahati Girls', 2, 'Swwiti Deka', 'English', 60),

('Assam', 'Gwahati Girls', 2, 'Swwiti Deka', 'Franch', 80),

('Assam', 'Gwahati Girls', 2, 'Swwiti Deka', 'Math', 90),

('Assam', 'Brapeta HS', 1, 'Michel Raja', 'English', 88),

('Assam', 'Brapeta HS', 1, 'Michel Raja', 'Franch', 56),

('Assam', 'Brapeta HS', 1, 'Michel Raja', 'Math', 34),

('Assam', 'Brapeta HS', 2, 'KK Halder', 'English', 67),

('Assam', 'Brapeta HS', 2, 'KK Halder', 'Franch', 35),

('Assam', 'Brapeta HS', 2, 'KK Halder', 'Math', 89);

SELECT * FROM [dbo].[tbl_SchoolDetails]

IDNo	StateName	SchoolName	StudentID	StudentName	StudentSub	StudentMarks
1	Tripura	Bothjung HS School	1	Joydeep Das	English	30
2	Tripura	Bothjung HS School	1	Joydeep Das	Franch	90
3	Tripura	Bothjung HS School	1	Joydeep Das	Math	50
4	Tripura	Bothjung HS School	2	Tapan Bhoumik	English	70
5	Tripura	Bothjung HS School	2	Tapan Bhoumik	Franch	30
6	Tripura	Bothjung HS School	2	Tapan Bhoumik	Math	80
7	Tripura	Pragati School	1	Haripad Roy	English	70
8	Tripura	Pragati School	1	Haripad Roy	Franch	90
9	Tripura	Pragati School	1	Haripad Roy	Math	90
10	Tripura	Pragati School	2	Tinku Saha	English	20
11	Tripura	Pragati School	2	Tinku Saha	Franch	80
12	Tripura	Pragati School	2	Tinku Saha	Math	10
13	Assam	Gwahati Girls	1	Tuinkel Khanna	English	10
14	Assam	Gwahati Girls	1	Tuinkel Khanna	Franch	40
15	Assam	Gwahati Girls	1	Tuinkel Khanna	Math	20
16	Assam	Gwahati Girls	2	Swwiti Deka	English	60
17	Assam	Gwahati Girls	2	Swwiti Deka	Franch	80
18	Assam	Gwahati Girls	2	Swwiti Deka	Math	90
19	Assam	Brapeta HS	1	Michel Raja	English	88
20	Assam	Brapeta HS	1	Michel Raja	Franch	56
21	Assam	Brapeta HS	1	Michel Raja	Math	34
22	Assam	Brapeta HS	2	KK Halder	English	67
23	Assam	Brapeta HS	2	KK Halder	Franch	35
24	Assam	Brapeta HS	2	KK Halder	Math	89

Step – 2 [ Create Base Data Source and Data Set ]

I think we can do it and no need to provide demo for that.

Step – 3 [ Insert List / Text Box ]

Now Insert a Text Box

Repeat the process until Student Name

Step -4 [ Insert a Table ]

Insert a Table and Bind It

Step – 5 [ Change the Tablix Property ]

Step – 6 [ Observe Output ]

Hope you like it.

Posted by: MR. JOYDEEP DAS