Some of our customized table have a total field in the headers that will only sum up all it's line items when user view the table. Because of this, when we use Jetreport to pull this field from all the companies in Navision, only the first company has a total value. The remaining companies all show 0 in this field.
Is there a way for Jetreport to trigger Navision to execute the cside codes to calculate the total field for every company it is pulling data from?
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi,
You can use the NP(Codeunit) function to execute a codeunit. I don't know which Dynamics NAV version you are using, but NP(Codeunit) is only available for code Units that are exposed via Dynamics NAV 2009 web services. You can send parameters to NAV and receive a value. -
Jet Reports Historic Posts We are currently using NAV 4.0 SP2. Plan to upgrade to 2009 end of this year. So even trigger to view is not possible thru JetReport?
-
Jet Reports Historic Posts Yes in NAV 4.0 SP2, it is not possible to execute NAV C/Side code through Jet Reports. After you upgrade to NAV 2009, this should be possible, but not in 4.0 SP2.
Regards,
Hughes -
Jet Reports Historic Posts So even trigger to view is not possible thru JetReport?
Maybe I'm misunderstanding you, but I'd say you could use the Drilldown button to open your Navision form. Or maybe you could recreate your NAV calculation with a Jet NL(Sum) function. -
Jet Reports Historic Posts Good point about Drilldown Hans. Drilldown will open the NAV client to the form associated for a particular table (with the same filters set as those used in the Jet formula). If it is a custom table or if you have changed the drilldown form for the table, you may need to export your NAV objects (as text) and import them into Jet so that it knows what drilldown form to use for a particular table. Does that help?
Regards,
Hughes
Please sign in to leave a comment.