Same filter returns different values during run

[#1]

Hi,

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?

[#2]

Ok. I found out that I had to remove the filter in tasks to avoid a filter on top of another filter. Removing filter from task resolved the case.