I can't seem to figure this one out.
i have a Jet Report, with jet functions in it.
for instance, here is a simple NF
=NF($C5,E$4)
But for some reason i save my report, open it back up and it is now showing as
='C:\Program Files\JetReports\JetReports.xla'!NF($C5,E$4)
I am using Jet Reports 7.1.0
I am using Office 2007
Connecting to a NAV 5.0SP1 database
Any ideas?
Date
Votes
8 comments
-
Jet Reports Historic Posts I've seen this before, and for me it goes away when I re-run a report. I've not seen it actually stop anything from working.
What you're seeing (I believe) is the fully qualified path to the Excel add-in (thats all jet is really).
I see this when I design on one computer, then open on another. Is that what you're doing here? -
Jet Reports Historic Posts Yes, that's it, i create it on one, and open it on another, or create the report, send it to the client, and then look at it on the client's computer.
I can still run the report, but if i want to make some changes in design mode, i have to take out the directory just to get to the jet function.
Meanwhile, if i come up with some other solution i will let you know. -
Jet Reports Historic Posts If you run it on your computer, then enter design mode, does that not correct the issue for you (for that time)?
Could you maintain a copy on your computer (or a shared location) where you can edit, then send copies to the client? (would not work if the client also needs to make changes). That was you are always working on your own computer.
Perhaps logging a ticket with offical Jet support might provide you with a solution (i find they are very good eventually)
cheers -
Jet Reports Historic Posts Hi there,
I am having a simmilar problem to cveale. However the path that is being inserted in my formulas is wrong.
Using the example given by cveale Jet is putting the path as
='C:\Program Files (x86)\JetReports\JetReports.xla'!NF($C5,E$4)
instead of
='C:\Program Files\JetReports\JetReports.xla'!NF($C5,E$4)
Because Jet inserts the wrong path I get a number of #NAME?'s as a result.
Can anybody tell me where Jet is getting this path from? Can I change it somehow? At the moment I'm having to use Find & Replace to remove all of the " (x86)"'s from my reports.
Thanks in advance for any replies!
Kind regards,
Mick -
Jet Reports Historic Posts I am having similar issues. I had JetReports 9 previously installed on Windows XP and Office 2010 32-bit and designed several reports in that environment. Then I got a new PC with Windows 7 and Office 2010 32-bit. Jet Reports installed to that "Program Files (x86)" location you guys have mentioned. Now when I try to refresh or go to design mode in one of the original reports (created on my old PC) not only do I have errors/problems but it will crash Excel and if I'm lucky there is a restored verson of my report when Excel is re-opened.
I'm considering uninstalling JetReports and re-installing under the "Program Files" location (NOT '(x86)'). Has anyone tried that? Success? Problems?
Thanks.
Jeff -
Jet Reports Historic Posts Hi Jeff,
You actually can't choose the installation path for Jet Reports in the installer. It will always install in the default x86 program files location. I would recommend you open one of your reports, do a find and replace for the "C:\Program Files\JetReports\JetReports.xlam!" and replace it with blank so that all your formulas are fixed (this will take some time because the formulas get calculated while they are being replaced but it should finish eventually). Then save the report and close and reopen it. If you do this, does it still crash when you run it? If so, you should create a support case with Jet Reports support.
Regards,
Hughes -
Jet Reports Historic Posts Hi. Thanks.
How can I replace the text in the formulas if Excel crashes each time I try to enter design mode?
Jeff
p.s. I just tried to 'unhide' everything in the Jet menu, that crashed Excel also. -
Jet Reports Historic Posts Hi Jeff,
I'm assuming you're using Excel 2010, is that correct? The crashing you're experiencing is a known issue in Excel 2010, that has very recently been fixed in a hotfix by Microsoft. The error occurs when a formula with invalid syntax is restored from a hidden sheet when entering Design mode, or when performing any operation that causes formulas to be restored (such as Unhide).
Please be sure that you first install Excel 2010 SP1, then install the hotfix found here:
http://support.microsoft.com/kb/2544025
Best Regards,
Please sign in to leave a comment.