Tip #20 - Save Report Usage

Marije_Brummel

This is a hot subject for a lot of companies using Navision. When was a report last executed, by whom and how many times.

The classic solution for this is to add code to every report to store this information in a table.

But it can be solved more generic...

The solution is in Codeunit 1. Here is a trigger FindPrinter that is executed prior to each report being printed. So what about implementing the solution here.

In order for this to work, we have to implement a trick, because when this code is executed, Navision is not yet in transaction state.

The trick is to save the report usage in a Temporary table first inside a SingleInstance codeunit.

Read more...

http://dynamicsuser.net/blogs/mark_brum ... usage.aspx

fcrespo

Congratulations for your code, it's very useful.

I have added a Navision Timer object to "Report Usage Mgt." Codeunit to save report usage periodically instead waiting till user Logoff Navision.

To active the timer ReportUsageMgt.RUN must be included to LogInStart() function in Codeunit 1

Belias

althought mark's suggestion was very useful in year 2009, microsoft has implemented this new feature:
http://blogs.msdn.com/b/nav/archive/2011/06/23/how-to-log-report-usage.aspx
enjoy

Marije_Brummel

Belias wrote:

althought mark's suggestion was very useful in year 2009, microsoft has implemented this new feature:
http://blogs.msdn.com/b/nav/archive/2011/06/23/how-to-log-report-usage.aspx
enjoy

Guess who convinced them...

Miklos_Hollender

I rarely go "wow" these days, but this is a definite case of it. Thanks a lot Mark, I owe you a beer for every ten Classic reports I don't have to redo in Visual Studio :-)

asanda9801156

Thanks Mark. this is really helpful.