Monday, December 29, 2008

SharePoint Tutorial: Connecting SQL Reporting Services to a SharePoint List

Sometimes you may need to create reports on the SharePoint list data. For example, you may need to create a report for your manager on surveys entered by your users. You can use SQL Reporting Services to connect to a SharePoint list and develop a report from that data.

I've created a tutorial and a video on how to do this.

If you have any questions, please post a comment and I will try to answer to the best of my ability.



10 comments:

bong hits 4 bill gates said...

could u do something on reporting services? thanks

Anonymous said...

Very informative post.

madhu said...

when i tried to create dataset i got error.

Jennifer said...

Hello everyone!

Madhu: I'm not really sure what error you are getting. I know that sometimes you can get some errors when trying to set up the connection to the service. There are also some "quirks" with setting up the connection. If you want some more details on troubleshooting, visit David Wise's blog post on this subject. He talks about the common "quirks" that occur when setting up a connection through Reporting Services.

Anonymous: Thank you.

bong hits 4 bill gates: I think I know who this is...anyway, I'll probably do something on reporting services in the near future.

Jennifer said...

To "Dixie":

While I got a kick out of your post (especially your name), unfortunately I couldn't publish it. I need to keep this site "work friendly" and "school friendly".

To answer your request - I will be doing some VB.NET tutorials and tricks. In fact, my next post is going to feature VB.NET.

rahul said...

Its Interesting post.

You might be interested in sharepoint tutorial
Sharepoint Development Tutorial

Jennifer said...

Hi Rahul,

Thanks for the compliment, and thanks for the link! I think that other readers will find it as informative as I did.

Anonymous said...

the document shared by you is very usefull in creating a report by calling single list from a sharepoint. now please share how to link multiple lists of a sharepoint as you have mentioned in document "Project Status Report" which includes risks, deliverables, issues against a single project.

Regards
Munira

Carlos said...

Excellent material. Do you have any reference for connecting SQL Reporting Services to a SharePoint FORM library instead? It seems that nobody out there has been able to connect by using webservice GetForm or GetFormCollection yet. Thanks.

Anonymous said...

Hi Jennifer,

Valuable post.
I am getting following error when creating dataset.

Could not generate a list of fields for the query.
Check query syntax, or click refresh fields on the query toolbar.

Additional information:
failed to prepare web request for the specified url.



I used the query string as said in the video.


http://schemas.microsoft.com/sharepoint/soap/GetListItem
s


Could please help me on this..

Thanks,
Ram