Unique Person

[Former Member]

Dear All,

I am using BEx Query Designer. I am making a report on an infoset. I use 0person. and the query gives info on a person basis. Problem is 0person is not unique since 1 person can have 2 hiredates. Is there a way where the query can be designed is such a way that only a unique person would be shown with the latest hiredate, if not that any 1 particular hiredate.Basically 0person should not repeat.

Regards,

Jack Silverz

[Former Member]

Try Hide repeated key values in the query properties in the header of the BEx query designer of your query

[Former Member]

Dear SDBI,

That option is already ticked in the query. 0person is displayed as key too. But still person is repeating.

Regards,

Jack Silverz