Error when running reports in CRM 4.0: Value cannot be null. Parameter name: g


When you have installed the SRS data connector for MS CRM 4.0, you may receive the following error message when trying to run a report from within CRM:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘CRM’. (rsErrorOpeningConnection)
Value cannot be null. Parameter name: g

My first thought was the datasource for the report was not set correctly.
I found out that CRM creates another datasource beside the standard DataSource located in the folder of your organisation.

So, this means you will have 2 datasource for your CRM organisation.
The default, located at <orgname>_MSCRM\MSCRM_DataSource
And the SRS data connector DataSource under <orgname>_MSCRM\4.0\MSCRM_DataSource

It seemed the SRS data connector DataSource was not configured correctly.

Make sure following configuration is set.

SRS data connector DataSource under <orgname>_MSCRM\4.0\MSCRM_DataSource:
Data Source Type: Microsoft CRM Data Extension
Connection String: MSCRM Data Connector Connection String

Connect Using: Credentials supplied by the user running the report (This setting was wrong in my case)

Default DataSource:
Data Source Type: Microsoft SQL Server
Connection String: Data Source=<ServerName>;Initial Catalog=<orgname>_MSCRM;Integrated Security=SSPI

Connect Using: Windows integrated security

Advertisements
Tagged with: ,
Posted in CRM 4
3 comments on “Error when running reports in CRM 4.0: Value cannot be null. Parameter name: g
  1. Deepu Mathew says:

    Thanks a lot!!! I was running into the same issue and this helped. 🙂

  2. Stacy says:

    Thanks so much! Was running into this issue and change the connection details as per your article solved it.

  3. Crystal says:

    Done well, you have gained a whole new fan, resources much like the one you mentioned here are very beneficial in my opinion. I most certainly will post a hyperlink to that page in my blog. Most likely my visitors will discover this very helpful, please visit my website sometime as well as leaving us a comment to allow me read your comments. Regards,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: