mscrmblog: This report requires a default or user-defined value for the report parameter ‘Parameter’. To run or subsribe to this report, you must provide a parameter value

[Blog bot]

Источник: http://mscrmblog.net/2010/12/09/this...rameter-value/
==============

ahhh sql reports — i mean come on this sounds like a simple parameter problem — however what seems to be the problem here is that in the report i was requesting from sql srs web services for CRM4 — you must define data source credentials with the datasource name being the datasource name on the report!!

then you get this error:

An error has occured during report processing —> Cannot create a connection to data source ‘DataSource1′ —> Guid should contain 32 digits with 4 dashes…

i’m kicking myself at this point saying WTF!!

This error occurs because the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services requires the user’s SystemUserId value as the Log in name and the user’s OrganizationId value as the password (for the datasource credentials)..

When a report runs inside Microsoft Dynamics CRM, these values are passed automatically. These values must be entered manually when the report is run directly from SQL Server Reporting Services.



DataSourceCredentials dsc = new DataSourceCredentials();
dsc.DataSourceName = "DataSource1";
dsc.UserName = "C9444B29-E6FC-DF11-9A31-005056AD3D4B"; // SystemuserId from the filteredUser table
dsc.Password = "D945754F-C1DF-DF11-81ED-005056AD3D4B"; // OrganizationId from the filteredUser table
DataSourceCredentials[] credentials = new DataSourceCredentials[] { dsc };

more info at: http://support.microsoft.com/kb/2006869



Источник: http://mscrmblog.net/2010/12/09/this...rameter-value/

[Артем Enot Грунин]

Просто опубликуйте отчет для внешнего использования. В этом случае на сервере отчетов будет создана копия с правильным источником данных на основании NTLM авторизации, а так же автоматически будут выложены и все подчиненные отчеты.