Hi,
This isn't really a "how do I", but I am hoping that someone may be able to help.
I have written a fairly simple report in Jet, pulling data back from Navision. The report is arranged by customer first using NL("Rows=2"…) and then for each customer by item NL("Rows"…..)
90% of the report comes back fine, but for a few of the sub records (the item section), instead of the values I am getting a black diamond with a white question mark inside it (Don't know if it will post OK but looks like this: � ). If I try to drill down on this then the correct value populates into the cell and I get the correct details.
Has anyone else seen this before? I have no idea what might be causing it and thus how to fix it.
Thanks for any help.
Regards,
Garry.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Garry,
For these types of questions, please create a ticket on the Jet Reports Support site. I'm sure someone there will be able to help you resolve this issue.
Regards,
Hughes -
Jet Reports Historic Posts Garry, did you get an answer.
I get these diamonds every so often. A re-write a report, a reboot of my server… different things fix it, but WHAT casused it could save me a lot of T&E next time.
Thanks! -
Jet Reports Historic Posts The diamonds are caused by some sort of issue in some performance optimization code (NF function optimization in 12.5, which was expanded to Batch Function Execution optimization in 14). You can find a setting to turn it off in the Jet Application Settings, although this may make your reports slower. I think Jet would much rather you report it via Jet Reports Support since it can then be fixed by the development team. Make sure you are on the latest version before reporting it though since many fixes have been made to the optimization code since it was released.
Regards,
Hughes
Please sign in to leave a comment.