Has anyone experimented with the Key option in 2010 ? In particular I'm looking for performace increases using one option over the other . I realize this may depend a lot on the individual report parameters but I have several users who are scheduling anywhere from 2 to 20 reports ( or more) nightly and they are beginning to run into maintenance/ backup windows and or slowing Navision down in general ( Yeah I know more processorrs more memory will cure anything Microsoft ) :roll:
Van
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Van!
I assume you mean the Key algorithm option on the Nav data source, right? This controls what algorithm Jet Reports will use to automatically pick keys. If you have a lot of knowledge about Nav keys (or would just like to experiment), you can actually use Key= in your formulas themselves to get even more control on exactly what key Jet is using for each formula. For example, you could force Jet Reports to use the key consisting of Document Type and Sell-to Contact No. on the Sales Header table like this:
=NL("Rows","Sales Header",,"Key=",{"Document Type","Sell-to Contact No."})
You might be able to use this to fine tune some of the longer running reports.
Regards,
Hughes
Please sign in to leave a comment.