Skip to Content
0
Former Member
Jun 09, 2008 at 07:09 PM

Display of Records in Query/Report

17 Views

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