February 10, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Problem Executing Report with Stored credentials in SharepointProblem Executing Report with Stored credentials in Sharepoint
Previous Previous
 
Next Next
New Post
 5/21/2009 2:40 PM
 
 Modified By Frédéric LATOUR  on 6/9/2009 5:04:58 PM

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 ??


New Post
 5/21/2009 4:47 PM
 

I found the solution!

The stored user should be in format "DOMAIN\User"  instead of "User".

http://christhedeveloper.blogspot.com/2009/02/report-server-in-sharepoint-integrated.html

Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Problem Executing Report with Stored credentials in SharepointProblem Executing Report with Stored credentials in Sharepoint

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement