I can run a jet report on my local machine without issue. When the same report is ran on the Jet Server the table formulas do not run and the when excel opens the file I get a message saying a Problem was encountered with the content. Any ideas? TIA
5 comments
-
Harry Lewis Hello Todd -
When you state "when the same report is ran on the Jet Server"... do you mean that you are opening a copy of the report on a different machine? Or accessing a data source on a different machine? Or...?
Could you include a screen shot of the error message?
-
Todd Morse I created a report on my machine (everything seems to work fine on my local copy) and uploaded it to the Jet server for distribution. When I open it from email or run it on the jet server then open it from the jet server I get.


And the NL("Formula",.....) function is removed from the excel spreadsheet.
Thanks
-
Harry Lewis Hi Todd -
In what way do you "upload" to a Jet server? Are you using the Jet Web Portal?
You mention - NL("Formula")...
do you mean NP("Formula") function that is listed in the NP Function Reference?
-
Todd Morse Yes I used the web portal and yes I meant NP. Thanks
-
Harry Lewis Thanks, Todd.
The issue may be that your NP function is used in a manner that is not currently supported in the Jet Web Portal.
If you do not believe that to be the issue, you'll want to submit a support request with the Jet Technical Support team, so that they can take a deeper look at your report.