Apply filter on cycle field for NPrinting 17 report
I am using NPrinting 17, release November 2018 (update to February release planned soon).
I generate a monthly report with data from the last 10 years. The report is generated for each of our locations / offices by using the location field to cycle the report. Some of these locations are no longer active and I would like to avoid an empty report being generated for them.
Is there a way to apply a filter to the cycle field?
In my QlikView application I use a flag to check if the location is / was active in my Max(Year) selected (Active_Flag). If I use this flag as a filter in NPrinting, the reports are actually only generated for my active locations but the data is also affected and only displayed for my Max(Year).
Well, this is the way to go - create a flag in data model, but create a flag which will not distract your data. Solution with the flag is the best approach, but how you need to model this flag in your data model you need to know by yourself. We will not be able to tell you this without looking at your app.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.