
Tweaking the GP Business Analyzer Charts with SQL Report Builder
Microsoft delivers many fancy charts and KPI's with Dynamics GP Business Analyzer. Most are fine out-of-the-box, but some need to be tweaked to get more useful information. Enter (stage left) SQL Report Builder! Even a beginner's knowledge of this tool will be helpful in improving the presentation of these KPI's. For instance, a pie chart where the labels sit on top of each other and without a total can be fixed up by setting a few chart properties and dragging a summary tota


Microsoft SQL Report Builder included with Dynamics GP 2013
It was there in GP 2010, but I didn’t pay much attention to it, because I thought it was just a watered-down version of SQL Server Reporting Services (SSRS). But this week I decided to look at it and do the online tutorial – to see what the value propositions were. It is an amazing tool! Reporting software has come a long way in the last 25 years. The first value proposition is that it is targeted at power users rather than I/T folks. In other words you don’t need to write p