2 Replies Latest reply: Apr 26, 2016 7:47 PM by Daniel Jenkins RSS

    Variable Filter not Working nPrinting Excel Report

    Lokesh Patel

      Hi Guys,

       

      Overview:

      • I have a QVW containing 3 Table Objects.
      • These Tables have multiple Date Columns like [Order Date], [Invoice Date] & [Payment Date]
      • Have an nPrinting connection with that QVW

       

      What am I trying Achive?

      I am trying to create Month-To-Date Payment report which should only show the Data where payment was made in the current month

       

      What I have done so far to achieve this?

      • Created a Master Calendar in QVW from field [Payment Date] to eliminate repeating dates.
      • Have Created a new field [Payment Month Year] by extracting Month & Year from [Payment Date]
      • Created a Dynamic Filter in nPrinting to select current month year on that [Payment Month Year] field

       

      variable.png

       

       

      What is the problem ?

       

      • I have applied this filter on the report level but not working
      • I applied at the task level and still not working
      • It is working fine when I open QVW and select current month manually
      • AND it is also working fine when I apply filter in Nprinting by selecting the month-Year Manually
      • It just not working as a variable.

       

      The Reporting Task is also  finishing with success but the excel report still contains data for all the months.

       

      According to the log.. it is also recognising the variable filter Date(Today(),'MMM-YYYY') as Apr-2016


      month-year.png

       

      Thanks you for your time