Duplicate first name is not showing SSRS report

Viewed 42

I have a SSRS report which gives total of monthly worked hours. But when the employee has same first name, then his first name is not displaying. Only last name only showing in the report.

enter image description here

A grouping has implemented in the SSRS report design as below enter image description here

Can anybody help me why the first name is not showing for 'Alexander'?

1 Answers

The duplicate first names are displayed together because there is a grouping on "first_name" like it shows in your screenshot. Remove the grouping on first name and keep all the rows and it should be fine.

Right click on First_name in Row Groups section > Delete Group > Delete Group Only

Related