Hello,
I am a new user to Jet Reports, but used other reporting tools … I have a couple of questions:
1) Is there any good training material other than the JR help manual that are free??
2) Is there capability to report on system logs of certain actions in Microsoft Dynamics Nav. I.e. Date and time when the status of a record change to "open".
3) How do I get familiar with the table names being used in Microsoft Nav? Is there something i can click in NAV to show me that info?
4) How do I filter and show rows of table A Filtering From table B? If there is a common field that ties them together.
Thanks in advance
Date
Votes
3 comments
-
Jet Reports Historic Posts Ill see if I can answer a few of your questions.
2) Is there capability to report on system logs of certain actions in Microsoft Dynamics Nav. I.e. Date and time when the status of a record change to "open".
You can use the "Change Log Entry" table and use filters to get what you are looking for. It may take some time to go through and get what you want but it is entirely possible.3) How do I get familiar with the table names being used in Microsoft Nav? Is there something i can click in NAV to show me that info?
Use the "Object Designer". From Nav toolbar click Tools -> Obect Designer (or Shift+F12). You will just need the proper permissions to use the "Object Designer". I personally find this incredibly helpful to be able to quickly look at all the table names in the database and then even be able to see the fields within each table as well as their contents.4) How do I filter and show rows of table A Filtering From table B? If there is a common field that ties them together.
Generally you have something like a Employee Number or Product ID or some key that is common between tables in order to filter on other tables.
Ex: Table A is your Employee table and Table B is your Sales table, both tables share a unique key called "EmployeeID". If you want to get a list of all employees (Table A) that work out of Florida and their sales you may want to return all instances of EmployeeID where the filter "state" = "Florida". This would return you a list of employee numbers that you could then use to filter Table B with to get your sales by those employees.
Hope this helps. -
Jet Reports Historic Posts I will take a try at your number 3 question.
In latest build of Jet Reports v9.1.9352.0 (avaliable on the support site) there is a non-documented feature which allows you to see the relationships between the tables and fields. In order to access this feature do the following:
1. Open your NAV database / company you are connecting to Jet with.
2. Go to your tools menu in NAV, Object Designer. (note: if you do not have access to the object designer you will need to call your NAV Partner and ask them to export the table and field definitions as a .TXT file, if your partner has done this for you skip to step 6).
3. Once you are in object designer to highlight all tables and fields press ctrl+A.
4. In NAV with the object designer still open and highlighted go to the File menu, Export, .TXT file format, and give the file a name you will remember.
5. Once the file has been created you can close NAV.
6. Open Excel if it's not already open.
7. Go to the Jet menu, click data source settings.
8. Once in data source settings click File, Import, Table Details. Browse and find the file with the .txt extension you just created.
9. Click ok and Jet will process the file.
10. Once Jet has completed the import you can then go to the Jet Browser tool and select/highlight any field or table then click your right mouse button. Click view details or you can also use the short cut of ctrl+T
By following the steps above you will be able to see details about the Properties, Keys, and Table Relationships of a table along with the table relations of a field.
Please let the community know if this posting/feature helps.
Paul -
Jet Reports Historic Posts In latest build of Jet Reports v9.1.9352.0 (avaliable on the support site) there is a non-documented feature which allows you to see the relationships between the tables and fields.
Which is great news! The Advanced Designer is back :D Ho-ho-ho :) Thanks for sharing this with us, Paul. And many thanks to the developers too :)
Please sign in to leave a comment.