We have a version of NAV that has many custom tables and as part of an upgrade to NAV 2009 we are planning to do some housekeeping and rename about 200 fields on various tables to more meaningful/accurate names. This obviously has an implication on our JetReports of which we have a couple of hundred templates and many thousand workbooks containing historic reports. To update all these workbooks by hand is obviously an enormous task! So does anyone know of a tool that could help with this?
Thanks,
Neil
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Neil,
I have no renaming tricks for you - maybe someone else has. However, here's an idea for future reports…
If you refer to the table and field IDs in your reports you may prevent renaming / international naming issues in the future. An example to clarify my suggestion…
=NL("Rows","Customer",,"No.","10000..50000")
can also be defined as
=NL("Rows","18",,"1","10000..50000")
or
=NL("Rows","18 Customer",,"1 No.","10000..50000")
In both examples only the IDs are used. The table name and field name in the 2nd example are ignored. I prefer the 2nd method though as I don't know all IDs by heart.
If you use NL("Caption","18 Customer","1 No.") you will get the updated caption from your database.
The only issues left are when the IDs are changed in NAV.
Please sign in to leave a comment.