Hi
The Data (First Name & Surname are attributes og Emp_ID as user need them in Drilldown)
Emp_ID......First Name.......Surname
1................Kumar.............pavan
2................murthy.............rama
3................Kumar.............pavan
I got two employees with same first name and last name (1 & 3)
When i execute a report
By Emp_ID by Firstname by Surname
It is displaying 3 records
1................Kumar.............pavan
2................murthy.............rama
3................Kumar.............pavan
If i remove Emp_ID from the report it is displaying 2 record s
Kumar.............pavan
murthy.............rama
How can achieve if i remove Emp_ID it should display 3 records
Kumar.............pavan
murthy.............rama
Kumar.............pavan
Please advise how to acheieve this