Reporting Services reports can be of great benefit to users of Dynamics GP by presenting relevant information to them on the home page and also in the Navigation lists. However, loading Business Analyzer in the Navigation Pane Fact Box can cause the lists to load slowly, so some customers want to disable Fact Box.
Unfortunately, Dynamics GP only allows Fact Box to be hidden manually by individual users, and needs to be hidden on each of the Navigation lists separately. Fortunately, Dynamics GP databases are stored in SQL Server and can be updated with a simple SQL Trigger, which runs each time a user opens a Navigation list for the first time; this recipe will show you how to add this SQL Trigger.