Complete list of Microsoft Dynamics GP 2010 R2 SSRS Reports

Inside Microsoft Dynamics GP has listed out all SSRS reports for Microsoft Dynamics GP 2010 R2.

The list categorizes reports by module and indicates whether it's a normal report or KPI based report. This would be the best document to make us aware of and convince our customers that GP does have such expansive list of standard reports and KPIs.

VAIDY

Microsoft Dynamics GP 2010 - Reporting (By David Duncan & Christopher Liley)

I just added one more treasure on my kit, in the form of a new book called Microsoft Dynamics GP 2010 - Reporting, written by David Duncan (I.B.I.S.) and Christopher Liley (I.B.I.S.), published by Packt Publishing.

I have started reading this book from today and hopefully in a week, I will be able to grab hold of the vast set of chapters.

To give you an overview of what is there inside this book: The book covers everything "reporting" in GP. From Report Writer reports to Smartlist to Excel Reports to SSRS to Analysis Cubes to Management Reporter. Every single thing about GP Reporting.

However, the book does not talk about two things:

1. Crystal Reports and the way you can access crystal reports from GP quite understandably because Crystal Reports is NOT supported out of the box by Dynamics GP. It can be used with the help some 3rd Party solutions, such as GP Report Viewer (from Flexible Solutions) or even a simple code piece written by any Consultant who knows GP, Crystal Reporting and .NET coding.

2. FRx, as this is already been replaced by Management Reporter. There is of course a section in this book where the difference between FRx and Management Reporter is explained.

I shall be writing a review of this book in a week's time (hopefully). Just could not wait to tell you all that this book really going to be a great treasure for those who wants to understand how effectively GP data can be visualized and analyzed.

Until next post.

VAIDY

Microsoft Dynamics GP2010 R2 - SSRS BI maxRequestLength Error

Another one, luckily Mohammad R. Daoud has got an answer to this issue.

Once GP2010 R2 installation is over and GP Utilities start configuring system, almost the last setup is SRS Reports Deployment wizard. It's a welcome change from previous versions, as this one is more explanatory and clear.

Once it starts deploying reports, the following error message is thrown:

The message is self-explanatory on what needs to be done to get rid of this message. To understand how to find WEB.CONFIG file, read Mohammad R. Daoud's post; Dynamics GP 2010 R2 Business Intelligence Installation Error maxRequestLength.

Thanks Daoud. It was really helpful.

VAIDY

Microsoft Dynamics GP 2010 R2 - SRS Reports Deployment Error

Everyone knows that GP2010 R2 got released well before it's announced date (1st May 2011). And I was no exception in starting off with it.

I installed GP 2010 R2 on my laptop and it went thru' merrily. And started off with deploying SSRS and Excel Reports. Below is the error message I am getting:

Reason: I am running SQL Server 2008 R2 Express. For some reason, SRS deployment do not recognize SQL Server Express editions and it requires either Standard or Enterprise.

So people, those who would wish to deploy SRS on SQL Server 2008 R2 Express, please do not.

VAIDY

List of Attractive BI Technologies from Microsoft

This was my second session today at Tech-Ed 2011 Middle East. Very interesting and demos were extremely useful to understand all the BI Technologies listed.

Now what exactly are we talking about? The session was all about listing the most promising (some are already existing) BI Tools running on top of either OR all of the following: SQL Server 2008 R2, SharePoint 2010, Silverlight.

The following are the list:

1. SharePoint Excel Services
2. PowerPivot Galleries
3. PerformancePoint (Dashboards, Scorecards & KPIs)
4. PowerPivot for SharePoint
5. Pivot Tool - based on Silverlight
6. Bing Data Connector - To show geospatial data
7. SQL Server 2008 R2 Reporting Services (Report Builder)

Each of them will take it's own time to allow user to understand the basics. I let my readers to BING or GOOGLE these terminologies and learn it.

But, the above list is what Microsoft concentrates more on currently to let users create the most attractive BI for them.

Enjoy.

VAIDY

Project Crescent - Beyond SSRS Reporting Tool

I must be following SQL Server Reporting Services Team Blog for loads of information and all that "What's Coming Up?".

Attending an evening session in Tech-Ed 2011 Middle East, and this is what I got to know which had been in fact announced some months back.

For those, who do not know about this (like me till this moment), this is the information. Project Crescent is a project currently on progress inside MSFT, which targets every kind of user, be it IT Developer or Corporate Power User or a No-Nonsense End-User) to visualize their Business Data; however they want it to be.

More information here: A Glimpse at Project Crescent.

VAIDY

Microsoft Dynamics GP 2010 R2 - 50+ New SSRS Reports

Yeah, we heard it right. We are going to have 50+ new SSRS Reports.

Inside Microsoft Dynamics GP excites us with this post: Feature of the Day: New SQL Reporting Services Reports.

I am more interested in knowing Field Service Reports, since that's where GP lacks a bit in terms of realtime reporting. I sincerely hope R2 fills that gap to most extent. Of course, requirements from different customers would always be different.

VAIDY

GP2010 - Sales Charts & KPIs - Top Items By Sale Amount - Stored Procedure Bug

I stumbled across a bug (of sorts) in GP2010 SSRS Charts & KPIs for Sales Module.

GP2010 has got default Charts & KPIs designed in SSRS and we have quite hands full of Charts & KPIs which covers most of our basic requirements. One module which is very good in terms of coverage is Sales. Under Sales, we have a Chart & KPI called Top Items By Sale Amount.

When I ran this report to view the results, I got the following error message:

The error message mentions that there is an extra bit of string data that's getting forcefully truncated due to size restrictions. This clearly indicates a SQL Error Message. I ran the SQL Profiler furthering the probe. And the issue was rounded in to a Stored Procedure which is run to extract the needed data for this Chart & KPI, which is seeSOPTopTenSalesItemsByPriceMetric.

In that stored procedure, a temporary table is created with a column named ItemNumber which is of size char(18). We all (Consultants/Developers) know that, in GP, size of a Item Number is 31 in SQL.

So, this SSRS Chart & KPI will fail if any Item Number exceeds the size 18 in variably, which is a bug in this Stored Procedure.

FIX: I ALTERed this stored procedure to resize this particular temporary ItemNumber column to char(31) and report retrieved the details excellently.

VAIDY

Deploying GP SSRS Reports - maxRequestLength Error & Resolution

I was deploying GP SSRS Reports on SQL Server 2008 64 Bit and was facing the following error message:

There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

Googled it and here the resolution: http://www.developmentnow.com/g/115_2006_4_0_0_735861/Request-Length-Exceeded.htm

I hope this would be a useful tip for people out there deploying SSRS for GP.

VAIDY

Setting up SSRS in Dynamics GP - Mariano's Input saved my day

I installed Dynamics GP 10, a fresh install to make sure that I properly install SSRS Add-On and configure it to GP 10.0.

Everything went on well and I started configuring SSRS Paths in Dynamics GP Reporting Tools Setup window.

I entered the path and I received a message "The Report server URL entered is not valid.". No clue, whatsoever.

I surfed and here I found Mariano's input to one of the users.

If you are busy enough to not going to that link and read, here is what Mariano had to say:

If you are on SQL Server 2005, the URL should be http://ServerName:PortNumber/reportserver/reportservice.asmx.
However, if your server happens to be a SQL Server 2008 server, the URL should be http://ServerName:PortNumber/reportserver/reportservice2005.asmx.

Thanks Mariano for this input and I am delighted to have succeeded in my task. Though this is for my own R&D, this has kick started a really interesting and sincere learning process.

VAIDY

Generate Charts Using SSRS

MichaelJ2 has pointed out to a very good article in SQL Server Central portal, which explains step-by-step on how to generate charts using SSRS.

As he mentioned in the end, it's worth to have a look since GP is moving more towards SSRS and it would be great to see more Decision Making charts generated right from GP.

VAIDY