While attaching a report as word document in CRM 2011 getting the error :

See more:

CRM

I am getting this error while setting SetDatasourceCredentials: An attempt was made to set credentials for a data source 'CRMDataSource' associated with the report. Report data source settings are specified in a way that prevents credentials from being submitted to the report server. ---> Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceNoPromptException: An attempt was made to set credentials for a data source 'CRMDataSource' associated with the report. Report data source settings are specified in a way that prevents credentials from being submitted to the report server.

The below is the code I am using:

  WhoAmIRequest req = new WhoAmIRequest();
                WhoAmIResponse resp = (WhoAmIResponse)sysService.Execute(req);
               
                string userName = resp.UserId.ToString();
                string password = resp.OrganizationId.ToString();   

eporting.WebForms.Internal.Soap.ReportingServices2005.Execution.DataSourceCredentials dsc = new Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.DataSourceCredentials();
                dsc.DataSourceName = "CRMDataSource"; //this is DataSource name in the actual Report.

                dsc.Password = password; //orgId
                dsc.UserName = userName; //userId

                Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.DataSourceCredentials[] Credentials = new Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.DataSourceCredentials[1];
                Credentials[0] = dsc;
               
               
               rs.SetExecutionCredentials(Credentials);

Please suggest.