I am trying to understand why my filter is not working as I would like it to when generating the report.
The filter logic: Max(MonthId)-1 should return data from last month ie. 2016-01. (24181)
This works fine when I preview the report in Nprinting and it seems to work fine in the first statement below.
The problem is that the e-mail generated report returns data for MonthId = 24180.
Any idea what can be wrong here?