Skip to Content
0
Former Member
Jun 04, 2008 at 01:00 PM

Time Dependent Navigational Attributes in Query

79 Views

Hi,

Location & Job are the Time Dependent Navigational Attributes of an Emp No and

Created a Info Set (outer Join) based on Emp No and DSO....

Created a Query based on the infoset and the Location * Job are Free Chars in the report

In the query property setting entered KEYDATE as 31.12.999

When i executed report and drilldown on Job or location it is displaying me 2 records for each employee one with Blank and the other with information.....

It should display only one record..most recent record avaliable in Emp master data

Where was i doing wrong