Can someone tell me if and how I can pull information for a JET report from two versions of NAV (5.0 and 2009) and two data base types (C-side and SQL) respectively?
Thank you in advance.
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi,
Yes you can pull information from multiple versions of NAV in a Jet report. You have to create a Jet data source for each NAV database you're connecting to. Then in your Jet formulas you can use a filter to make the function pull data from a particular data source. You can even make the data sources options in the report so you can set which data sources the report is pulling information from at runtime. In an NL formula the filter would look like this:=NL("Rows","Table","Field","DataSource=","Data Source Name")
In the GL function, there is a specific argument for the data source and NF functions and most NP functions don't need a data source filter. If you want information from more than one data source in the same report, you will have to have a Jet function for each data source and then you can combine the results. Does this make sense?
Regards,
Hughes
Please sign in to leave a comment.