Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

Nprinting condition or filter

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 .

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

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.

View solution in original post

9 Replies
everest226
Creator III
Creator III
Author

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

Year(now())-6

Daniel_Jenkins
Specialist III
Specialist III

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
Creator III
Creator III
Author

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
Specialist III
Specialist III

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

- Daniel.

everest226
Creator III
Creator III
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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
Creator III
Creator III
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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
Creator III
Creator III
Author

sure i will create another thread, thanks Daniel