SRS MS Dynamics GP reports not visible in Custom Reports

SQL Reporting Services reports are normally visible in the Navigation Pane, under Home, in Report Shortcuts, Custom Reports.

When a user in Dynamics GP clicks on Custom Reports the repots list should populate in the Custom Report List to the right. 

In this case the user clicks Custom Reports and nothing happens, there is no error, and the reports do not populate the list.

This problem is related to security.  The relationship between active directory, sql, SRS, and MS Dynamics GP is a complicated one.

This solution assumes you have SRS, Active Directory, MS Dynamics GP setup properly, and you have run the MS SQL Reporting Servies wizard for GP and it has installed properly and been configured.  Furthermore, the computer that the user is on has not been excluded or blocked by IIS, and that the computer hasn’t been blocked by a firewall issue.

Delete the GP user in MS Dynamics GP.  Setup a new user.  Give them the proper access to companies and security.  At this point you can assign Power User rights and test.   Lauch Dynamics GP and login as the new user.  Click Custom Reports.  The list should populate.

If this works you are probably good.  Change security for the user.  Have them log in and test.  Keep an eye on it because sometimes it will break again, and you may have to repeat the process.

If this does not work you have a different issue with SRS, IIS, active directory, etc.