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.
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
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.
the best way for you
will be to create month field in the script with this expression
monthstart(date) as Month
Retrieving data ...