How to Publish Salesperson-Specific Data to the Field with Microsoft Dynamics GP and SQL Reporting Services
I was recently engaged to resolve an issue a new client was having with Business Portal for Dynamics GP. It didn't take long to figure out that the problem wasn't with Business Portal, but rather the way they were trying to use it and NOT using SQL Server Reporting Services (SSRS). Both tools have a place in their environment, but one is not a substitute for another. They complement each other. This client, like most Dynamics GP customers, really needed to be leveraging the strengths of both together.
Its goal was simple; deliver relevant data to the sales organization in the field through the web browser. Its requirements were not much different from those of any other sales organization. It Its priorities were that 1) the reports were simple to use and 2) the sales people didn't have to filter out other sales territory or sales person data.