Create indented child rows in SSRS report

Question

I am trying to figure out how to create indented child rows under the parent, in SSRS report. I am quite new to SSRS, the group by function works in a different (and obvious) way then what I want.

I have a sample dataset as below.

Declare @Employee Table(Code varchar(10), Name varchar(500), 
Organization varchar(100), IsChild bit, ParentId varchar(10))

insert into @Employee Values('BR456','Brandon','XYZ',0,NULL)
insert into @Employee Values('CR674','Carolina','ABC',0,NULL)
insert into @Employee Values('ME230','Melissa','PQR',1,'CR674')
insert into @Employee Values('JR987','Jerome','LMN',0,NULL)
insert into @Employee Values('JO435','Joseph','IJK',0,NULL)
insert into @Employee Values('ME321','Meghan','UVW',1,'JO435')

Here, Melissa is child of Carolina & Meghan is child to Joseph. I am looking for below result. I could not find example matching this.

Is it possible to make this using some formatting options?

Code       Name       Organization
BR456      Brandon    XYZ
CR674      Carolina   ABC
  ME230    Melissa    PQR
JR987      Jerome     LMN

Jayvee Jayvee · Accepted Answer · 2015-10-25T12:33:35

you can use the padding options: right click on the cell you want to indent, [Code] in this case, then select Text Box Properties -> Alignment then, under Padding options, click the Expression button (Fx) and replace whatever is there (probably "2pt") with this expression:

=IIf(Fields!IsChild.Value="False","2pt","8pt")

Create indented child rows in SSRS report

2 Answers