Nprinting condition or filter

[everest226]

I have to generate report from tab which will get the whole tab object, i have only one field based filter to get data for one country. country is in listbox.. now question is i have year list box and months listbox but i only  want  data from july to till this date .report runs every months. what is best practice and how .

[everest226]

i did some changes in filter field and it work, might be helpful

Year(now())-6

[Daniel_Jenkins]

Hi Ujjwal,

I can't see how Year(now())-6 - which results in 2010 (2016 - 6 = 2010) - will filter your data for "July till this date". I can't understand what you want exactly. For instance, what would you want to be returned in February 2017?

- Daniel.

[everest226]

i mean months(now())-6

but you are right ,

what i am trying to get is from july 2016 to current months so in 2017 feb i want data from 2016 july to feb 2017

[Daniel_Jenkins]

What version of NPrinting are you using? Can you paste a screenshot of your filter definition?

- Daniel.

[everest226]

Nprinting16. i am out of office. wish i could attach screen shot

[Daniel_Jenkins · Accepted solution]

Since you are using version 16, I suggest you create a new field using a valid existing date field (I'm using OrderDate) in the load script like so:

Year(OrderDate)& num(Month(OrderDate),'00') as YearMonthNum

and use that in a field filter:

You can make it more dynamic by using functions like Year() & Month() to build whatever value you want.

HTH - Daniel.

[everest226]

Thanks , just a question how do i fit  sheet in world report,somehow in report it dose not fit

[Daniel_Jenkins]

Hi Ujjwal,

Please create a new thread for unrelated queries so others will benefit when searching these forums.

For your particular issue I suggest that you attach a simple sample QVW & screenshots of the issue in the new thread.

Best,

Daniel.

[everest226]

sure i will create another thread, thanks Daniel