how to apply filter on another sheet in excel template in nprinting

[engr_farhanqadr]

Hi Folks,

I am stuck in problem I have a report of branches . I need to show each month report on each excel sheet through Nprinting. I have date filed how can I apply each field value on each sheet.

Thanks

[lironbaram · Accepted solution]

hi

it's actually fairly easy

use the Date field as a page in the excel template

and it'll automatically creates a sheet per value in the date field

[engr_farhanqadr]

thanks for the answer one more thing. In that date field I have different values I only want year 2016 month end in that list box.

I wrote   '=if( Year([CURRENT_DATE.Current Date])='2016',MonthEnd([CURRENT_DATE.Current Date]))'  in formula but it is not working.

[lironbaram]

hi

the best way for you

will be to create month field in the script with this expression

monthstart(date) as Month