Options

AS On Date

divyesh10divyesh10 Member Posts: 71
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
](*,)

Comments

  • Options
    divyesh10divyesh10 Member Posts: 71
    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)
Sign In or Register to comment.