You’re offline. This is a read only version of the page.
Hi
I followed the sample in this link to generate pdf report using the reportexecution2005 web service, in dynamics crm 2015, but I get the following error:
An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in System.Web.Services.dll
Additional information: An attempt was made to set credentials for a data source 'CRM' 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 'CRM' associated with the report. Report data source settings are specified in a way that prevents credentials from being submitted to the report server.
Error being thrown at following line of code, when reaches to rs.SetExecutionCredentials line.
DataSourceCredentials[] credentials = new DataSourceCredentials[1];
credentials[0] = datasetCredential;
rs.SetExecutionCredentials(credentials);
Is there a way to solve this ?
*This post is locked for comments
Hi
I use 12.0.200 Version. I did not understand "BIDS 2008 R2", but our sql server version is 2014.
I have already deployed the report and it is being shown in Dynamics CRM Reports.
I have checked the log and did not find anything regarding access.
what version of SSRS? have you tried on BIDS 2008 R2
I never used 2005 but 2008 R2 worked fine for me for CRM reports.
have you deployed any reports previously on this server?
Check credential access with SSRS server and CRM server
do you see anything in the trace log of CRM server if preventing access?
also check SSRS logs too
Hi
SSRS/SQL report
fetchxml or standard SSRS/SQL report?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (