Question Status

Verified
Darren Hunt asked a question on 14 Nov 2012 2:27 PM

We ran Reporting Tools Setup for GP 2010 R2 (11.00.2044) to deploy the SSRS reports to SQL 2005 Reporting Services.  The "reports" deployed successfully for our production company and the TWO company; however the "Charts and KPIs" failed to deploy for both companies.  This is causing an error message to appear when navigation lists (e.g. Purchasing>>Vendors) are selected from w/in GP because the Business Analyzer component used by the navigation list cannot find the Charts and KPIs folder and its contents.  Any ideas?

Reply
Verified Answer
Rob Bernhardt responded on 15 Nov 2012 6:14 AM

Darren,

I wanted to add the following to Mike's response.  He is correct in the SRS 2008 requirement.  So you are clear, you need not upgrade completely to SQL 2008.  You can leave your database engine with SQL 2005 and simply install an instance of SQL 2008 reporting services.  This could be an easier short term solution if you don't wish to completely upgrade to a new version of SQL Server.

Thanks

Rob

Rob Bernhardt [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply
Suggested Answer
Mike S responded on 14 Nov 2012 4:51 PM

The charts and KPIs leverage Report Builder 3.0 which is a feature of SQL Server 2008.

Requirements are:

Microsoft SQL Server Reporting Services 2008 32-bit or x64 in Native Mode or SharePoint Mode

Microsoft SQL Server Reporting Services 2008 R2 in Native Mode or SharePoint Mode

mbs.microsoft.com/.../mdgp2010_technology_requirements.htm SQL Reporting Services Charts & KPIs

Reply
Suggested Answer
Mike S responded on 14 Nov 2012 4:51 PM

The charts and KPIs leverage Report Builder 3.0 which is a feature of SQL Server 2008.

Requirements are:

Microsoft SQL Server Reporting Services 2008 32-bit or x64 in Native Mode or SharePoint Mode

Microsoft SQL Server Reporting Services 2008 R2 in Native Mode or SharePoint Mode

mbs.microsoft.com/.../mdgp2010_technology_requirements.htm SQL Reporting Services Charts & KPIs

Reply
Verified Answer
Rob Bernhardt responded on 15 Nov 2012 6:14 AM

Darren,

I wanted to add the following to Mike's response.  He is correct in the SRS 2008 requirement.  So you are clear, you need not upgrade completely to SQL 2008.  You can leave your database engine with SQL 2005 and simply install an instance of SQL 2008 reporting services.  This could be an easier short term solution if you don't wish to completely upgrade to a new version of SQL Server.

Thanks

Rob

Rob Bernhardt [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply