Condition in nprinting

[Smeenakshi23]

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

[rubenmarin · Accepted solution]

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

[Smeenakshi23]

Once the Usage date gets selected i want to use many filter conditions at the time of Importing recipient..

Is that possible ?

(i.e) only after selecting the 180 days usage date the next filer has to be applied

. will that work in that way ?

[Smeenakshi23]

Also where  do u set  isLast180Days=1 in Nprinting. There is only two selection like is numeric and evaluate.. Where to specify this condition. is it possible to attach a screenshot

[Chanty4u]

Elaluvate you can use.

number you can use when the values like   Year  ,month,day like that number values

[rubenmarin]

Hi Sorundarya, sorry for delay. I don't fully understand the requirements, also I haven't done many recipient imports so most probably I don't know how to do it.

Is this for NPrinting 16?

[Smeenakshi23]

Yes it is Nprinting 16