AS On Date

divyesh10

I have to set filter for a report for As on date
i.e i should only print the latest records in the report
for eg if i apply filter 3/1/14
then i get following date
1/1/14
2/1/14
3/1/14
so report should only print record for 3/1/14
and if 3/1/14 is not available in report like if i got
1/1/14
2/1/14
for the same filter then the record for 2/1/14 should be printed
](*,)

divyesh10

I have done the following code

FindDate := FALSE;
IF "HR Employee Component".FINDFIRST THEN BEGIN
IF "HR Employee Component"."Start Date" > AsOnDate THEN BEGIN
FindDate := TRUE;
END;
END ELSE BEGIN
FindDate := FALSE;
END;
and added the visibilty in matrix report as
=IIF(fields!FindDate.Value=true,false,TRUE)