Hi
Just upgrading to Jet 2009 and having trouble with drilldown forms for non-standard tables.
I know the help shows the correct way is to export text files from Object Designer/table design (which I think was the case in previous versions too) but for those of us without table design permission this means asking our Navision provider to do it for each table (at a cost!).
In previous versions it was quick and easy to add new drilldown forms by editing the drillforms.txt file in Program Files\JetReports, which we then copied across the network all to users.
I’m unable to find this file or a new equivalent so, at the risk of getting flamed for bad practice :evil: , does anyone know of such a workaround in the new version ?
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi sdej,
The drilldown forms are now stored in an xml file in the Jet Reports application data directory. To get there, go to Start -> Run and type %appdata%\Jet Reports and press ENTER. The drilldown forms for each data source are stored in an xml file with the filename "[DataSourceName] Drilldown Forms.xml" where [DataSourceName] is the name of the data source. The format of this file has changed from Jet Reports v7, but if you open the file in notepad and examine it, it should be obvious how to add or modify the drilldown forms defined in it. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts That’s great, thanks Hughes.
The command didn’t work because of some local problem here, but I get the idea its C:\Documents and Settings\[User Name]\Application Data "[DataSourceName] Drilldown Forms.xml" (for XP anyway). Have added some new tables & forms and works fine.
cheers
Shane -
Jet Reports Historic Posts I'm trying to update the DrillDown forms in 2009, but I don't seem to have the [DataSourceName] DrillDown Forms.xml anywhere. Can anyone provide an example of what it looks like?
-
Jet Reports Historic Posts Hi aize_s,
The file would only be there if you had previously uploaded drilldown forms (either in Jet Reports v7 or 2009). If you have never uploaded your drilldown forms into Jet Reports, the file will not exist. To upload your drilldown forms, export your table objects from Navision as text (sometimes a solution center has to do this). Then open the Jet Reports Data Source Settings and go to File -> Import -> Drilldown Forms. Browser to the text file containing your Navision objects and click OK. Does that help?
Regards,
Hughes
Please sign in to leave a comment.