Answered by:
Reporting Server Issues

Question
-
Donna,
Your first link refers to a "run the Report Manager"
Error message when you run a report in Microsoft Dynamics CRM 4.0: "The report cannot be displayed"
What report manager. I don't have anything by that name and there is nothing in CRM like that.
Can you calrify?
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.com- Split by Donna EdwardsMVP Thursday, June 3, 2010 7:10 PM
Tuesday, June 1, 2010 7:26 PM
Answers
-
The Report Manager runs on the CRM Report server. It is the directory that stores the CRM reports. You can open the Report Manager by going to http://crmReportServer/Reports. See these steps in the article for more information:
- Open Reports Manager.
- Select the CRM Organization.
- Click Show Details.
- Click the v4 folder.
- Click the CRM Data Source.
Regards, Donna
        Windows Live Blog
- Proposed as answer by Donna EdwardsMVP Thursday, June 3, 2010 7:13 PM
- Marked as answer by Jim Glass Jr Friday, June 4, 2010 3:00 PM
Tuesday, June 1, 2010 10:05 PM -
The login box indicates a security issue. Something is not set correctly for your Report Manager which I suspect is at the root of your issue. You'll need to sort out your security issues associated with the Report server.
Regards, Donna
        Windows Live Blog
- Proposed as answer by Donna EdwardsMVP Thursday, June 3, 2010 7:13 PM
- Marked as answer by Jim Glass Jr Friday, June 4, 2010 3:00 PM
Thursday, June 3, 2010 4:10 PM
All replies
-
The Report Manager runs on the CRM Report server. It is the directory that stores the CRM reports. You can open the Report Manager by going to http://crmReportServer/Reports. See these steps in the article for more information:
- Open Reports Manager.
- Select the CRM Organization.
- Click Show Details.
- Click the v4 folder.
- Click the CRM Data Source.
Regards, Donna
        Windows Live Blog
- Proposed as answer by Donna EdwardsMVP Thursday, June 3, 2010 7:13 PM
- Marked as answer by Jim Glass Jr Friday, June 4, 2010 3:00 PM
Tuesday, June 1, 2010 10:05 PM -
I go to that locationa and I keep getting a login box. I enter my credentials (I own the SQL databases and am a CRM sysadmin with that acconut) and it seems to reject it. I never get an error message, but I get a blank page. If I refresh, we go through the whole thing again.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 3:42 PM -
The login box indicates a security issue. Something is not set correctly for your Report Manager which I suspect is at the root of your issue. You'll need to sort out your security issues associated with the Report server.
Regards, Donna
        Windows Live Blog
- Proposed as answer by Donna EdwardsMVP Thursday, June 3, 2010 7:13 PM
- Marked as answer by Jim Glass Jr Friday, June 4, 2010 3:00 PM
Thursday, June 3, 2010 4:10 PM -
I downloaded the IIS 6.0 resource kit and installed it. I am looking at troubleshooting the problem.
However, I looked at the virtual directories and do not see one for "Reports". Shouldn't there be one for "Reports" by default?
I hated working with IIS in its previous incarnation. Version 6.0 is much worse.
I started out using WFetch to see how IIS is responding to the URL.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 4:29 PM -
WFetch does not have a Windows Authentication option so I am not sure I am getting an accurate pricture since the IIS settings are for Windows Authentication.
Is there a better tool to troubleshoot this problem with? I'v eused WFetch many times in the past with success. I will look through the other tools in the resource kit.
Greg
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 4:58 PM -
I can now get the SQL Server Reporting Services screen. One data source is listed - SDI_MSCRM - which is the CRM production database, but I get the following message when I click on it:
"There are no items in SDI_MSCRM. Click Help for more information about this page."
I think I am making progress (??). I at least seem to be past the initial authentication issue.
I reset the service account to a network account.
This may be complicated by the fact that there is a MSSQLSERVER instance of SSRS and a CRM instance of SSRS. I'm not sure how the original installers managed to do that, but it undoubtedly complicates the situation.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 5:23 PM -
Now I can get to reports through SSRS (web interface) but I get the following error when I try to run one:
-
An error has occurred during report processing. (rsProcessingAborted)
-
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
- Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
-
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
- I seem to have a problem getting to my data source, but do not understand why.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 6:43 PM -
An error has occurred during report processing. (rsProcessingAborted)
-
Not sure I know what we are trying to solve at this point. I think the initial question was 'What is the Report Manager' and I answered that one.
Regards, Donna
Thursday, June 3, 2010 7:08 PM -
I am still trying to get reporting for CRM working again. The installation of SQL Server Reporting Services for CRM broke it. I've been working both sides - SSRS and CRM - to try and diagonse the problem. So if it seems like I'm jumping from one to another - I am.
I probably should rethink this and start a new thread for specific inquiries. I've asked a couple of other SDI consultants to give me a hand. I've been stuck on this for days.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 7:12 PM -
" The installation of SQL Server Reporting Services for CRM broke it"
I don't understand what you mean by the above. Do you mean install the SRSS Connector? What steps did you take before Reports broke.
I have some time this evening if you need a hand. I can setup a remote session and have a look around. If there is anything that needs changing, I'll direct you and won't make changes myself.
Regards, Donna
Thursday, June 3, 2010 7:16 PM -
I installed the SSRS connector and the updates (up to rollup 10). Reports stopped working after that.
I just uninstalled the connector (but not rebooted yet) and the reports are still not working. I plan to reboot at 5 PM and try a report again.
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comThursday, June 3, 2010 9:40 PM -
If CRM and SQL are on different servers, reboot both if you are able. If the reports are still not working from CRM, look at the CRM server Application Log in the event viewer and see what error you have. You can also run a repair on the SRSS Connector.
Regards, Donna
Thursday, June 3, 2010 9:57 PM -
I uninstalled SSRS connector for CRM, Repaired SQL install and the CRM install. I applied the updates again. SSRS is working and reporting is working from within CRM.
Tonight I plan to install the SSRS connector for CRM again and see if it works or breaks reporting again.
Progress! (finally)
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comFriday, June 4, 2010 3:09 PM -
SSRS connector for CRM is installed. My reporting is working and I can now schedule reports. It all appears to be working now.
Thanks for the comments.
Uninstall, reinstalls, reconfigure, and install and update finally fixed it. Whewwwww!
Gregory N. Brooks Secure Data Inc. gregory.brooks@securedatainc.comSaturday, June 5, 2010 12:10 AM -
Sunday, June 6, 2010 3:26 AM