Hello All,
I want to make a report which should be updated after inserting data into a specific cell.
When I am working in the develloper enviroment a record is updated instantly when a cell to
which the record/formula is refering to is changed.
In the viewer mode this is not the case. Is there a method/workaround to achieve this.
Hope you can help me. Thanks.
Henri
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Henri -
The Jet Excel add-in is optimized to provide designers with immediate feedback as they design their reports. The data returned by this optimization is meant to represent data from the data source, but not necessarily the final results of a report or individual query. To obtain correct results, it is necessary to run the report.
Typically, a Jet report should only be updated using one of two methods:
1) Clicking either the Refresh or Report button on the Jet ribbon in Excel
2) Selecting a report and clicking Run when in the Jet Web Portal
There are other other methods for updating reports (such as running a report from within Dynamics NAV or launching the Jet Excel add-in from other MS Office apps by running a VBA script), but these are very specialize situations. It is possible to refresh a report through Excel macros, but macro-enabled reports can also interfere with Jet functionality and, thus, are not supported. -
Jet Reports Historic Posts Thank you for your reply.
Regards,
Henri
Please sign in to leave a comment.