Reporting!!!!

[Sridharan]

hello all,

here goes my table structure and sample data


Acc No Date Amount Balance Flag

1001 01-10-02 5000 2000 N
1001 05-10-02 8500 3200 N

1001 03-10-02 450 3420 S
1001 06-10-02 1450 3750 S


now for each account no and its flag based on a user defined date it should take the maximum date and present the amount
and the balance for that account. say for eg. user says 10th Oct 2002 as the cut off date then it should take for each account no and its corresponding flag the maximum date less than 10th Oct 2002 and give the amount and balance. like this


Acc No Flag N Amount Flag N Balance Flag S Amount Flag S Balance

1001 8500 3200 1450 3750


here for 1001 and N 05-10-02 is the max date and the corresponding values are displayed. similarly for flag S 06-10-02 is the maximum.

any idea on how to create a meaure so that i can get the above report.

many a thanks

sri

 

[vani65]

Hi Sri,
have you resolved this ? if so please explain me how? -- i got similar requirement