1 Reply Latest reply: Feb 10, 2016 7:01 AM by Freddy Johnsen RSS

    Same filter returns different values during run

      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?