0

Advanced Scheduling

Jet Reports Historic Posts

March 19, 2009 20:41

None

Follow

I am having issues with advanced Scheduling where I can't see excel range on the Update Report Options.

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts March 26, 2009 15:24 Official comment

  To get the "Update Report Options" in the scheduler to work, the first thing that you need to do is define an Excel Named Range for the cell you wish to update. When you define the named range, it can refer to only 1 cell. You must then save the report before you attempt to schedule it or the named ranges will not show up in the "Update Report Options".
  
  Also, as to using Today(), you should put it in an NP("Eval") formula.
  =NP("Eval","=Local(TODAY())")My understanding of how the Local function works is to translate it to the correct language, but I'm not sure, someone working with a different language would have to test it.
  
  For information about Excel Named Ranges and example uses see the following websites:
  

  http://www.homeandlearn.co.uk/me/mes9p2.html http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=187471&d=1025&dateformat=%25o-%25B. http://www.contextures.com/xlNames01.html
• 0
  
  Jet Reports Historic Posts March 24, 2009 18:41

  revman,
  
  this could be because of the following.
  
  1) Report have not been saved since you defined the Excel Range.
  2) Excel Range refers to more than 1 cell.
  
  Either (or both) could cause this problem.

• 0
  
  Jet Reports Historic Posts March 25, 2009 08:28

  Sherman, what do you mean by "excel range refers to more than 1 cell"?
  I specify excel ranges all the time with a column of cells…

• 0
  
  Jet Reports Historic Posts March 25, 2009 21:43

  I also have the same problem - never have I had any Excel Ranges or filter values come up in the "Update Report Options" field for any report. Is there something special you have to put in the Options tab in Excel to get them to appear in here? I need to schedule a report to run every night at 7pm for each day so I need the filter to change for each day. It says not to use "today" formulas as they are volatile in the "help". I tried this anyway and I email the report to myself, but when I open it the next day, of course the date comes up as today - even though the data is from yesterday. Any ideas?

• 0
  
  Jet Reports Historic Posts March 25, 2009 23:00

  Very wierd, is it possible to attach a copy here?
  
  I use datefilters with =today() all the time (otherwise scheduling wouldn't be much use tbh :))

• 0
  
  Jet Reports Historic Posts March 26, 2009 00:08

  Here's the file, Jan. Yes its a bit hard to schedule if you need to update the date without using =today() :)

  • Sales Invoices & Sales Orders by order date.xls