0

Generate new sheet per day of month

Jet Reports Historic Posts

July 29, 2013 17:18

None

Follow

Hello everyone.

I do believe I've got a very simply question, my old colleage did this at my old job but we have since moved on and I'm trying to put this foward in my new company.

I'm simply trying to run my report where every day of the month the report will generate a new sheet =today()-1

I do realize I need to create a NL Sheet function but I'm obviously missing something.

Any help would be greatly appreciated.

Thanks all

Adam

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts July 29, 2013 17:35

  Attached is our options TAB of the report.

  • Options Tab.xls
• 0
  
  Jet Reports Historic Posts July 29, 2013 22:23

  Hi,
  
  I'm not sure I quite understand what you are trying to do. Are you saying you want a sheet for each day starting at the beginning of the month and ending with the current day?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 30, 2013 15:16

  Esentially yes, a new sheet starting the first day of the month, and and ending one day previous
  
  (Ie today is the 30th, so my report would (hopefully) create a new sheet for the 1-29)

• 0
  
  Jet Reports Historic Posts July 30, 2013 18:50

  Are you using Microsoft NAV? If so, you could use the Date table for this. Your NL(Sheets) formula might look something like this:
  
  =NL("sheets","Date","Period Start","Period Type","Date","Period Start",NP("DateFilter",DATE(YEAR(TODAY()),MONTH(TODAY()),1),TODAY()-1))
  Obviously this formula could be split out into multiple cells and made more efficient and easier to read, but it should give you the basic idea. Does this help?
  
  Regards,
  Hughes