I am having the issue in GP 2010 R2; I am trying to publish the Dyanimcs GP's SSRS Reports to SQL 2008 R2 Reporting Server using its Reporting Tools Setup form but few companies are showing SSRS as not implemented. Redeploying the reports doesnt publishes the models and reports of these companies. Please help.
*This post is locked for comments
[quote user="gregpalmes"]
To save anyone else time / having to open a case, there's a simple query to flush that company's SSRS settings so that you can cleanly redeploy the canned reports. We had the old settings for some reason get stuck for one of many companies during a test upgrade. Once you flush it, the tool will then magically work for that company.
Select * Into DYNAMICS..sydeployedreportsbak
from DYnamics..syDeployedReports
where companyid = '<company interID with issue>'
Delete DYNAMICS..syDeployedReports
where companyid = '<company interID with issue>'
[/quote]
Finally something that worked. Thanks!
I fixed this by simply entering the information in the Reporting Tools Setup window, and then clicking the Refresh button located to the right of the deployment options. After refreshing, the red circles turned to check boxes and I was able to check them and deploy both SSRS and Excel reports without any issues.
To save anyone else time / having to open a case, there's a simple query to flush that company's SSRS settings so that you can cleanly redeploy the canned reports. We had the old settings for some reason get stuck for one of many companies during a test upgrade. Once you flush it, the tool will then magically work for that company.
Select * Into DYNAMICS..sydeployedreportsbak
from DYnamics..syDeployedReports
where companyid = '<company interID with issue>'
Delete DYNAMICS..syDeployedReports
where companyid = '<company interID with issue>'
I have a similar problem after an upgrade from 2010 to 2013. New companies show as deployed however our upgraded company shows "Not implemented" even though the reports are deployed. Must be a sticky flag or something.
A call to support may be the next best option at this point.
Yes I click those and the one for redeploy all reports. On 2 of the companies below the screen they show reports deployed and those will redeploy but the others do not. I can print out a status for all companies and it shows the reports are deployed for all companies and lists all the reports.
Have you tried checking the boxes below?
Share
Report
All responses (
Answers (
5
