There is a custom table in our Database NAV 2009 SP1 Classic SQL that Jet can not work with. I try to use the Report Wizard to just to return the rows with a simple NL rows and it does not get out the Jfx but just sits there until I have to close out of Excel and return to Excel again. This does not happen with any other tables that I am aware of. Even if you try to use this table in a another Jet report to try to link too it will just keep calculating and not show any output. Any ideas as to why this may be happening? Below is the needed information to make an informed theory.
NAV 2009 SP1 database and client
Excel is 2003
Jet reports version is 9.1.9274.0
Any thoughts would be appreciated.
thansk
Patrick
Date
Votes
3 comments
-
Jet Reports Historic Posts Have you tried using the table number rather than name in formula NL("rows", 123456,"field")
since you said this was a custom table there are couple other questions that come to mind ( does it have unique key and or does it have some sort of odd permissions on it ?
No this is not an answer per se but might give you a starting pomt -
Jet Reports Historic Posts Van
Thanks for your assistance. I tried doing a straight NL(Rows,50002 (the table no.), to get all rows in table but still just hangs in the fx and Jfx boxs. There is a uniqe key setup and there are no special permissions. I can run the table with in object Designer. Plus, I am a SUPER user. Something strange is going on. I wonder if a bug or Jet version issue. Been working with Jet for over 4 years and never had this problem before.
Thanks -
Jet Reports Historic Posts Hi Patrick,
It's possible that C/Front is having trouble accessing the table for some reason. Can you log a support case on http://support.jetreports.com so somebody can help you out?
Regards,
Please sign in to leave a comment.