Question Status

Verified
Terry Dickens asked a question on 28 Mar 2013 5:49 AM

I am having a problem getting SSRS reports to show on on the Home Page Metrics.  I saw this post, https://community.dynamics.com/gp/f/32/p/47256/85388.aspx, but still can't get SSRS reports to work.

We are on GP2010 11.00.1524 (SP1).  SQL Server = Microsoft SQL Server 2008 R2 (SP2) - 10.50.4276.0 (X64).  The name of the SQL server is "wayne".

On the Tools-Setup-System-Reporting Tools Setup screen there are 3 tabs.  Here's what I have for each tab.

SQL Server Reporting Services tab = http://wayne/ReportServer/ReportService2005.asmx   The Sharepoint option is unchecked.

Data Connections tab = http://wayne/ReportServer/ReportService2005.asmx

Reports Library tab = http://wayne/ReportServer/ReportService2005.asmx

Does anyone see what I'm doing wrong?  Thanks for your help.

 

 

Reply
Terry Dickens responded on 28 Mar 2013 6:05 AM

I forgot to add that the error I'm getting is this:

The item '/AECI/Dynamics GP/GP Financial Reports/AECI/Purchasing/Charts And KPIs/Payables Aging' cannot be found. (rsItemNotFound)

Reply
Rob Bernhardt responded on 28 Mar 2013 7:15 AM

Terry,

Where are you seeing this error?  I'm assuming AECI is your company database name?  The hierarchy of folders is a little confusing to me.  I wouldn't expect to see "/AECI/Dynamics GP/GP Financial Reports" at the beginning.  Is that something you created/modifed, or what that created by the deployment wizard?

Thanks

Rob

Rob Bernhardt [MSFT]

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

Reply
Terry Dickens responded on 28 Mar 2013 7:24 AM

We are seeing this error in GP, on the Metrics section of the Home Page.  AECI is the company database name.

I wasn't at this company when GP2010 was installed.  So I don't know much about the hierarchy of folders.  I do know that on Internet Explorer I can go to http://wayne/Reports/Pages/Folder.aspx, and there are folders listed.  I can click folders and eventually drill down to the report we are trying to run in the Metrics.  And that report will run in Internet Explorer. 

Reply
Rob Bernhardt responded on 28 Mar 2013 7:40 AM

Terry,

Could you describe you report hierarchy?  I would expect something like the following:  root > TWO(company db name) > Sales > Charts and KPIs > Total Sales YTD.

Thanks

Rob

Rob Bernhardt [MSFT]

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

Reply
Terry Dickens responded on 28 Mar 2013 8:07 AM

In Internet Explorer, I can go to http://wayne/Reports/Pages/Folder.aspx.

Then I click on the "AF" folder.  Then I click on "Dynamics GP" folder.  Then the "GP Financial Reports" folder.  Then the "AECI" folder.  Then the "Purchasing" folder.  Then "Charts and KPIs" folder.  Then finally I see the "Payables Aging" SSRS report that I can click on and run.

Reply
Verified Answer
Rob Bernhardt responded on 28 Mar 2013 8:21 AM

Terry,

Your report folder hierarchy is quite different than I'd expect, so I'd suggest re-deploying your srs reports.  I believe you'll need to use the srs deployment wizard, which can be installed from the Dynamics GP media.  After deploying, you should see a hierarchy like I had mentioned previously, which should work on your GP home page.

Thanks

Rob

Rob Bernhardt [MSFT]

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

Reply
Verified Answer
Rob Bernhardt responded on 28 Mar 2013 8:21 AM

Terry,

Your report folder hierarchy is quite different than I'd expect, so I'd suggest re-deploying your srs reports.  I believe you'll need to use the srs deployment wizard, which can be installed from the Dynamics GP media.  After deploying, you should see a hierarchy like I had mentioned previously, which should work on your GP home page.

Thanks

Rob

Rob Bernhardt [MSFT]

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

Reply