cancel
Showing results for 
Search instead for 
Did you mean: 

Display of Records in Query/Report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

As already suggested by ramesh, the thing that you want to achieve is not possible, you have to have a info-object that will seprate each record.

You can also make this clear to your client.

Thanks

Dipika

Former Member
0 Kudos

Hi bw learner,

You hide the EMP_ID characteristic in query designer.

1. Keep the EMP_ID in the rows.

2. go to properties of EMP_ID.

3. Change the option "Display as" to "No Display".

4. Save and execute.

I hope this will solve your issue.

Regards,

S P.

Former Member
0 Kudos

hi,

unless the records were differentiated by other infobject, the system will consider both are same. hence use the emp_id to have three records else use any distinguishing filed.

Ramesh