reporting services - Instead of line break need a straight line -

i have used lookupset in ssrs. how can draw line inside row?

currently, i've added line breaks adding vbcrlfs. instead of line break need line.

is possible?

table1:

person_id   name    salary_revisions 1           test1   100 1           test1   200 2           test2   300 2           test2   400 

table2:

person id                  department        organizations -------------------------- ---------------- --------------- 1                          physics             test1 1                          chemistry           test2 2                          maths               test3 

i result like:

person_id             name               salary_revisions       department     organization --------------------- ------------------ ---------------------- ---------------------------- 1                     test1              100                    physics          test1 1                     test1              200                    chemistry        test2 2                     test2              300                    maths            test3 2                     test2              400 

to have added 3 data sets. dataset1 contain person_id , name. dataset1 added dataset in tablix properties, means base dataset. second dataset2 contain person_id , salary_revisions. third dataset3 contain person_id, organizations,department.

for getting salary_revisions have added expression =join(lookupset(fields!person_id.value,fields!person_id.value,fields!salary_revisions.value, "dataset2")," " + vbcrlf+vbcrlf).

for getting department have added expression =join(lookupset(fields!person_id.value,fields!person_id.value,fields!department.value, "dataset3")," " + vbcrlf+vbcrlf).

for getting organization have added expression =join(lookupset(fields!person_id.value,fields!person_id.value,fields!organization.value, "dataset3")," " + vbcrlf+vbcrlf).

by doing facing issue while adding large department split 2 lines. corresponding organization not comes in same line.

please find result get.

person_id             name               salary_revisions       department     organization --------------------- ------------------ ---------------------- ---------------------------- 1                     test1              100                    physics          test1 1                     test1              200                    chemis           test2                                                                         try           test3 2                     test2              300                    maths           2                     test2              400 

my department table width 200 in database. can't make more design adjustments. can please me implement this.

there few different ways insert lines.

• add row black background color. shrink height , set cangrow false.
• place line image row , set repeatx (horizontally).

with each of these can use expressions if needed control when appear. example, if have sort of group id, can use previous function check if starting new group , have line show then.