Matrix Report for As On Date

Business Central/NAV Technical Forum
1

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
Brick wall

2

If running on RTC (2009 or 2013) you can keep in a variable the greatest date and in Visual Studio add a visibility condition to your table line, in Hidden propery, like =IIf(Fields!Date.Value = Fields!MaxDate.Value),True,False).

If running on Classic Client it’s necessary to fetch all the records before the dataitem, find the maximum date and use it with CurrReport.SHOWOUTPUT(Date = MaxDate).