How can I make the next question?
After a migration to an new Navision Client we've got 2 Navision Databases.
I want for example the next information: The enddate of a project
This project can excist in the old database, in the new database but also in both. When the 'enddate' excist in de new database then I want that the 'enddate' from that database. But when not I use the 'enddate' in the old database.
Who have a solution for me?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
In Jet Reports, you would need to set up a data source for each of your Navision databases. Then you can use 2 separate Jet functions with "DataSource=" filters to try and get the end date from each database. Then you can just use Excel functions to compare each result and pick the correct result. Does that make sense?
Regards,
Hughes
Please sign in to leave a comment.