Skip to Content
0
Former Member
Jul 28, 2009 at 07:49 AM

Report Output with Key Date

19 Views

Dear All,

I have the following fields in DSO.

Key Part: EmployeeID, DateTo, DateFrom.

Data Part: Designation, AnnualSalary.

I have data in the DSO as follows:

EmployeeID DateTo DateFrom Designation AnnualSalary

1 12.11.2008 01.01.2008 Worker 10000

1 31.12.9999 13.11.2008 Officer 20000

2 14.11.2008 01.01.2008 Worker 10000

2 31.12.9999 15.11.2008 Officer 20000

Now If I give key date as 13.11.2008.

The Output of the Report should be like this:

EmployeeID Designation AnnualSalary

1 Officer 20000

2 Worker 10000

How can I achive this ??

Cheers,

Neel.