0

jetreports.xlam error between 32 & 64 bit

Jet Reports Historic Posts

June 06, 2013 06:58

None

Follow

Hi,
I'm not too familiar with Jet Reports, but our accountant has made an Excel file which links to Jet Reports
It looks to have links to C:\Program Files\JetReports\JetReports.xlam

If it is opened on a 32bit version of Windows it behaves, however when the Excel file is opened on a 64bit version it complains because it cannot find JetReports.xlam
This is due to it being located in the C:\Program Files (x86) folder

If we update the link to this folder it works, until someone on a 32bit Windows opens the file then its in reverse

Is there a way to get around this?

thanks
Scott

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts June 10, 2013 14:46 Official comment

  Hi Matthias and Scott,
  
  If you use +Values or +Lock on your reports and save them in report mode after running them, then that should fix the problem. If there are Jet formulas on the report, then Excel will try to update them, but with +Values or +Lock in report mode there aren't any Jet formulas to update and when the Jet formulas get copied back into the report, they should be correctly linked to the current Jet addin. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts June 10, 2013 12:33

  Hi there,
  
  I've got the same effect. Is there a possibility to design reports that work with both - 32bit an 64 bit?
  
  best regards,
  Matthias

• 0
  
  Jet Reports Historic Posts June 11, 2013 06:51

  Hi Hughes,
  
  that's it. Thanks a lot.
  
  best Regards,
  Matthias

• 0
  
  Jet Reports Historic Posts June 13, 2013 05:19

  Spot on
  Thanks Hughes