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.
Monday, December 29, 2008
Subscribe to:
Post Comments (Atom)
10 comments:
could u do something on reporting services? thanks
Very informative post.
when i tried to create dataset i got error.
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.
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.
Its Interesting post.
You might be interested in sharepoint tutorial
Sharepoint Development Tutorial
Hi Rahul,
Thanks for the compliment, and thanks for the link! I think that other readers will find it as informative as I did.
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
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.
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
Post a Comment