Get better error messages while trouble shooting modified sub-reports in CRM 2011

So, you downloaded an existing CRM “out of the box” sub-report. Pulled it into Visual Studio. Changed a query or two, added some fields and changed the font. Now you are ready to publish the modified report. You log into CRM and go to reports, select the sub-report you want to replace and select edit. You then browse out to your modified RDL file and upload to CRM. But, when you try to run the report all you see is “Error in sub report.”

You have two choices. Take out each of your customizations one by one until you find the one that broke the sub-report. Or, run it directly from Report Manager.

But wait! You say. I tried that. When I try to run the sub-report I’m prompted for user name and password. I enter a CRM admin username and password and click “View report.” And, I get:

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).

This happens because you aren’t entering the correct user name and password.

Open SQL Management Studio and run the following query against your Organizations CRM database:

select FullName, SystemUserId, OrganizationId from SystemUser

Use the SystemUserId for the username and the OrganizationId for the password.

The report may not return any data but the error message will be much more specific.