0

Reference not valid

Jet Reports Historic Posts

August 23, 2013 15:27

None

Follow

Hello
I have installed Jet Report Express for NAV 2013; everything is configured, the connection is OK.
But when I want to run the pre-built reports, like for example Sales statitics created by Stephen J. Little, I always get a message error 'Reference not valid'.
Before posting this message, I read the existing posts, I tried to solve my issue but no success.
All fields seem to be good; no #value…. The data are well displayed in the Excel Sheet, with the right data extracted from the database but impossible to refresh any cross-table.
Additional informations :
- Excel 2013 French
- Settings : language selected in the Jet add-in : ENU
- Language interface : french

Those settings are not really the good ones because in the data Excel sheet, I have some fiels with name in English (OK) but some fields in French (Option). Why not all fields in french or English ?

Waiting for a solution

Kind regards

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts August 27, 2013 18:14

  I am not sure where the reference error is coming from.
  Can you check the named ranges for any #REF errors.
  Also if there are any dates set for criteria, be sure they are set to your regional settings format.
  
  To get all the language settings to match to NAV, you can export it from NAV, and point to it in Jet:
  http://kb.jetreports.com/article/AA-00511/0/
  
  Regards,

• 0
  
  Jet Reports Historic Posts August 30, 2013 09:11

  Check the date fields! I ran into similar issues and found that for me (also European) the problem was that dates were given in American standard, instead of European.
  
  Might be a simple fix to your problem…

• 0
  
  Jet Reports Historic Posts September 12, 2013 20:09

  Hi Frank,
  
  We recently made a change to Jet Express 2013 which changed the way table names are defined in Table Builder reports. This change made some reports built on earlier version of Jet to not work with Jet Express 2013.
  
  I suspect this is the issue that you have encountered.
  
  Can you apply the quick fix which is shown in the attached file and advise back if this resolved your issue?
  
  
  
  - We're updating the sample reports to eliminate this issue.
  
  Sorry for the any inconvenience this may have caused.
  
  Steve

  • Reference is not valid - error and fix.docx
• 0
  
  Jet Reports Historic Posts October 29, 2014 16:20

  I am having an issue with the GP028 report (Vendor PO Status). I receive the Reference Not Valid error when trying to refresh. The one thing I think that may be missing is the Info tab. Being new to this, does anyone know if this may cause the issue? If so, how can I add/correct the error?