Hello,
I have a problem executing a report published to Sharepoint using stored credentials.
I read from a List in Sharepoint. I also have a Shared DataSource dsPortal and two datasets ds1 and ds2 that use dsPortal.
4 report parameters exist. All of them are internal and datetime. (e.g dsParam1 =Today().AddHours(20).AddMinutes(0))
In VS.net and in Sharepoint (integrated mode credentials) there is no problem executing the report. But when I use stored credentials I get an error.
What I do is:
1) Create a new Report Data Source in the Data Source Folder. I set its name to dsPortal, set the datasource type to Enesys Sharepoint List, use stored credentials, specify the right connection string and
2) Upload the report in the Shared Reports library and specify the Report Builder Report ContentType.
3) Set the Datasources: I use the Shared Data source option and select the Shared DataSource I created previously.
Then I try to execute the report and I get the following error message:
An error has occurred during report processing.
o Query execution failed for data set 'ds1'.
+ For more information about this error navigate to the report server on the local server machine, or enable remote errors
(ds1 is one of the 2 Datasets I use.)
Any Ideas ??