Reporting on SharePoint list data?

Hi,
Can anyone direct me to a step by step tutorial on how to create a Reporting
Service's XML Dataset that queries a SharePoint list? I have found bits and
pieces in the SQL Books on line but I have not been able to put it all
together.
Thanks
Jeff.Hello again,
I was able to setup a dataset that queries a SharePoint list so I don't need
help on that any more :-).
The new problem: The report run fine in my development environment but when
I deploy my report and I try to run the report from the RS server I get an
"Query execution failed for data set 'DataSet1'" error. Since the
SharePoint server is running on a different machine I suspect that RS is
running the web service call under the identity of the ASP.NET thread which
does not have rights on the SharePoint server. I tried modifying the thread
pool that IIS is running RS but after I did that Report Manager would not
run any more :-(
What is the correct procedure to get RS to run under a domain account?
Thanks
Jeff.
"Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
news:uTVyJEaiGHA.2208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Can anyone direct me to a step by step tutorial on how to create a
> Reporting Service's XML Dataset that queries a SharePoint list? I have
> found bits and pieces in the SQL Books on line but I have not been able to
> put it all together.
> Thanks
> Jeff.
>|||Hello Jeff,
Thank you for posting in the MSDN newsgroup.
As for the reporting service accessing SPS list data issue, I think your
thought on the security permission is reasonable. At development time in VS
IDE, it use the logon user as the security context to access any remote
datasource (if require authentcated) user. However, after you deployed it
to reportServer, if you haven't explicitly set any credential for the
datasource(used in the report), it'll still use the authenticated user(if
you choose integrated windows credential) or the report server's service
account(if you do not specify any credentials).
Anyway, changing the report server's service identity is certainly not
recommended. I suggest you consider choose a certain credential supply mode
for your SPS datasource. We can configure credentials for report datasource
through two means:
1. In the DataSource's "Credentials" properties at design-time in VS IDE.
2. Use the report manager to configure credentials info for datasource
after deploying to report server.
Here is the BOL reference about how to specify credentials for datasource
connection:
#Specifying Credential and Connection Information
http://msdn2.microsoft.com/en-us/library/ms160330.aspx
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Jeff,
Have got any further progress on this issue or does my last reply helps you
a little? If there is anything else we can help, please feel free to post
here.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)