We have recently implemented Great Plains 2013 and we are now in the process of implementing SSRS for reporting.
We currently have a couple of reports designed by our contractor and I will like to perform certain adjustments myself to these reports.
After making a copy of the report that I want to change (backup purposes), I am using SQL Server Report Builder to edit this report. Basically the report consist of a Bar graph which Y axis is "Amount in sales" and the X axis is the Customer Number. This report shows the Top 10 customers.
The change that I want to perform consist on including the customer name in the X axis along with the customer number. What will be the steps to take to make this possible?
I am inexperienced on this tool, so feel free to post any reference that will help me understand how to use the SQL Server Report Builder with Great Plains and how to retrieve data from the Great Plains db.