1 Reply Latest reply: Sep 14, 2017 3:23 AM by Ruben Marin RSS

    Condition in nprinting

    soundarya meenakshi

      I have a filed as Start date in Qlivkiew applciaiton, while automating Nprinting report i need data only for 180 days from today..

       

       

      How to do that in Npritning and how to include that in while automating repots

        • Re: Condition in nprinting
          Ruben Marin

          Hi Soundarya, I think the easier way is flag this records in script, in calendar table, or in fact table if there is no calendar.

           

          This field can be used as filter for the report, ie:

          LOAD ....

               If(Today()-DateField<=180, 1, 0) as isLast180Days

          ...

           

          And set a filter in NPrinting like isLast180Days=1