Report Output with Key Date

[Former Member]

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.

[Former Member]

Hi,

I think you can achieve this by using a formula with boolean operators "is less than" and "is greather than", and then also use row/columns settings and/or conditions to suppress rows that does not contain the key date.

BR,

Niclas

[neelesh_jain3]

Yes. That looks promising.

Will try and come back.

Cheers,

Neel.

[neelesh_jain3]

Resolved.

Thank you all.

Cheers,

Neel.

[Former Member]

Hi Neel,

Have you specified the query to run of key date in the query?

Thanks,

Nick.

[neelesh_jain3]

Yes, I have. But even though it is getting all the records.

Cheers,

Neel.