Answered by:
CRM Reporting Services (Reporting Errror)

Question
-
I'm having a problem with creating reports in CRM.
After I construct a report, when I go to view the report, it says "Reporting Error, the report cannot be displayed"
When I go into my CRM application server into the event viewer, I see that the fllowing error has occurred when I tried to run the report...
Source: MSCRMReportingWeb service request GetDataSources to Report Server http://<company>-crmsql/ReportServer failed with SoapException. Error: The path of the item '/<company>_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
So, I then go to reporting services web portal into the <COMPANY>_MSCRM-->4.0 folder and try to run a report directly out of report manager. When I do, I get the following error...An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
Value cannot be null. Parameter name: g
Can someone please give me an idea of what might be happening here?
Thursday, September 10, 2009 3:43 PM
Answers
-
I am guessing that something is wrong with connection string.
So Download the report from MSCRM (go to Report screen --> Edit Report --> download report). this will be downloaded as .rdl file and then open this file in visual studio or notepad and check the connection string.
it should be something like ...
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=MOSs;Initial Catalog=MicrosoftCRM_MSCRM</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
if connection string is different then try updating as above and then upload report back to CRM (go to report screen --> Edit report --> select Report Type as existing file and then Browse to update file and save the record).
hope this helps...let me know- Marked as answer by Jim Glass Jr Thursday, September 10, 2009 7:29 PM
- Unmarked as answer by trallan Thursday, September 10, 2009 7:30 PM
- Marked as answer by trallan Thursday, September 10, 2009 7:43 PM
Thursday, September 10, 2009 4:33 PMAnswerer
All replies
-
I am guessing that something is wrong with connection string.
So Download the report from MSCRM (go to Report screen --> Edit Report --> download report). this will be downloaded as .rdl file and then open this file in visual studio or notepad and check the connection string.
it should be something like ...
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=MOSs;Initial Catalog=MicrosoftCRM_MSCRM</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
if connection string is different then try updating as above and then upload report back to CRM (go to report screen --> Edit report --> select Report Type as existing file and then Browse to update file and save the record).
hope this helps...let me know- Marked as answer by Jim Glass Jr Thursday, September 10, 2009 7:29 PM
- Unmarked as answer by trallan Thursday, September 10, 2009 7:30 PM
- Marked as answer by trallan Thursday, September 10, 2009 7:43 PM
Thursday, September 10, 2009 4:33 PMAnswerer -
Ok, so what you recommended helped. I changed my connection and the report worked.
Here is what the connection properties were before i changed them
<ConnectionProperties><DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial catalog=Adventure_Works_Cycle_MSCRM</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity></ConnectionProperties>
Why is my connection string defaulting to adventureworks? Can I change this?Thursday, September 10, 2009 7:30 PM -
I restarted IIS and now everything is working great.
Thanks for your help :)Thursday, September 10, 2009 7:43 PM -
I have this exact same connection string! How can I fix this without downloading all the reports?Tuesday, April 13, 2010 11:55 PM