Sunday 26 February 2017

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