I have written a number of Jet reports that access both standard Navision tables and tables from an add-on that is maintained by our Navision provider. Drilldown to the standard tables works perfectly, but drilldown to a table in the add-on results in an error message: "Drilldown form not found", even if a drilldown form for the table is defined in Navision.
According to the manual, I have to import a text file with (a) table definition(s) into Jet. Our licence prevents us from generating those text files (we can only export .fob files). Our Navision provider seems reluctant to give us those text files wholesale, and in any case, the tables change rather frequently, which means that with every new version of the add-on some tables would have to be re-exported by them.
Is there a way around the import/export of table definitions that will make drilldown work even for tables in add-ons?
Hans
Date
Votes
7 comments
-
Jet Reports Historic Posts Hi Hans,
Unfortunately there's really not much of a way around this. You could manually create the file Jet Reports will use to get drilldown forms, but you would have to add every table (including the standard ones) that you would want to drilldown on. The file you would need to add is in "%AppData%\Jet Reports" and the filename is "%DataSourceName% Drilldown Forms.xml" where you need to replace %DataSourceName% with the name of your Jet data source.
The file is just a text file and the format looks like this:
<?xml version="1.0"?>
<drilldownForms xmlns="http://www.jetreports.com/DrilldownForms">
<drilldownForm>
<table>3</table>
<form>4</form>
</drilldownForm>
<drilldownForm>
<table>4</table>
<form>5</form>
</drilldownForm>
<drilldownForm>
<table>5</table>
<form>6</form>
</drilldownForm>
</drilldownForms>
So this is saying that the drilldown form for table 3, is form 4, for table 4, it's form 5, for table 5, it's form 6, etc. You would need to add another <drilldownForm> node for every table you want to drilldown into with the NAV form number for that table. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hello Hughes
Yes, thank you, this is tremendously helpful. I can find the IDs of the tables and their DrillDown forms (if defined) in the Object Designer, and writing the XML is a matter of copy and paste (and changing a few IDs).
Thanks,
Hans -
Jet Reports Historic Posts According to a private message sent to me by hfousert, it should also be possible to specify the DrillDown forms in the Centralized User Settings Database (if one uses it - we don't)
database Jet Reports Settings
table TableDetails
field DrillDownFormID
Thanks again, Hans and Hughes! -
Jet Reports Historic Posts Hans Fousert is correct. You can store the drilldown forms in the centralized settings if you're using them (which is nice because you don't have to worry about copying a file to each user's machine).
Regards,
Hughes -
Jet Reports Historic Posts I tried Hughes' solution, and it works! A little time-saver: importing an empty text file in Jet -> Data Source Settings -> Import -> Drilldown Forms causes Jet to write the file "%DataSourceName% DrillDown Forms.xml" with entries for all the standard NAV tables. To this file I then only had to add the relevant tables from the add-on.
One problem though: for one of the tables, drilldown brings up the correct drilldown form, but with the wrong record (always the first in the table). I will probably have to ask my Navision provider about that one. -
Jet Reports Historic Posts Hi Hans!
I'm glad that worked for you. Nice trick as well! I wouldn't have expected that, but it's good to know.
As far as the wrong record, that is odd. I'm guessing it's related to the keys in the table somehow or possibly to the form itself, but it's hard know without the exact details. Good luck getting it resolved!
Regards,
Hughes -
Jet Reports Historic Posts Hi guys !
I know i'm unhearthing an oooold subject but I'm faced by a somehow related problem : I want to change a drilldown form from the default form associated to the table to another form. But I don't want to alter my nav forms, just swap form for Jet.
But I guess that Jet's way of doing thing evolved a bit as I can't seem to find the folders in the same location :
I have a jet Reports Folder there :
%AppData%\Roaming\Jet Reports
Where i can find "%Data Source Name% Drilldown Views.xml" and "%Data Source Name% Favorite Tables" but not what is indicated :/
Any idea how I could swap the form number ?
Ps working with the latest version of Jet Essential and Nav 2009 R2
Tjanks a lot !
Please sign in to leave a comment.