How to modify Great Plains SSRS reports with SQL report builder?

Hello All,

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.

Thank you!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:


To show all category labels on the x-axis

1.Right-click the category axis and click Axis Properties. The Axis Properties dialog box opens.
2.In Axis Options, set Interval to 1. Every category group label is displayed. If you want to show every other  category group label on the x-axis, type 2.
3. Click OK.


When an axis interval is set, all automatic labeling is disabled. If you specify a value for the axis interval, you may experience unpredictable labeling behavior depending on how many categories are on the category axis.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LuiLui77Author Commented:
Hi lcohan, Thank you for your post!

I have change the values of the interval to 1, 2 and auto and no change has reflected.

I can see int the Datasets are pulling info from a store procedure called: seeRMTopCustomersMetric

Any ideas?
lcohanDatabase AnalystCommented:
Are the customer name/number returned by the sproc? maybe you can add those(if possible) if they are not and see if they are available for selection on axis X. or create your own custom SP and use that one instead so anything else using the GP one is not broken.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.