SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - Business Intelligence
>
Reporting on Sharepoint Content
Reporting on Sharepoint Content
- I've been trying to find information on how to get started with creating reports based on information stored in sharepoint lists and libraries. It seems all reporting in sharepoint has to do with usage (I don't need this). I've read that SQL reporting services might work, but sharepoint lists aren't directly accessable via sql and there's a list of work arounds and hacks that are needed. There is a "plugin" for SRS but it looks like this is for placing already working reports in webparts. If anyone has any solutions for reporting whether using SRS or 3rd party tools, it would be appreciated. Specifically, I'm looking to have automated reports emailed to decision makers that say things like how many widgets were sold in the last 30 days, etc. Dashboards will not satisfy the requirement.
Thanks- Moved byMike Walsh MVPMVP, ModeratorFriday, October 30, 2009 4:34 AMssrs q (From:SharePoint - General Question and Answers and Discussion)
Answers
- you can use Sharepoint webservices to make reports on reporting servicesArticle:If you need to understand the Database Structure of Sharepoint content this article can help:Microsoft dont support changes you make directly on Database but you can follow what microsoft recommend about"Support for changes to the databases that are used by Office server products and by Windows SharePoint Services"
André Lage Microsoft SharePoint, CRM and Sybase Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 06, 2009 6:03 AM
- Hi,
You can generate documents and reports from information stored in SharePoint lists using "SharePoint document and reports generator" from www.sharepointdrive.com . It alows you to create Word 2007 templates with custom tags that are replaced at the time the report is generated. Reports can be stored in SharePoint lists or return to user on the fly. At the moment there is no automated email sending functionality but i think you can achieve this using workflows in SharePoint.- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 06, 2009 6:03 AM
All Replies
- you can use Sharepoint webservices to make reports on reporting servicesArticle:If you need to understand the Database Structure of Sharepoint content this article can help:Microsoft dont support changes you make directly on Database but you can follow what microsoft recommend about"Support for changes to the databases that are used by Office server products and by Windows SharePoint Services"
André Lage Microsoft SharePoint, CRM and Sybase Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 06, 2009 6:03 AM
- Hi,
You can generate documents and reports from information stored in SharePoint lists using "SharePoint document and reports generator" from www.sharepointdrive.com . It alows you to create Word 2007 templates with custom tags that are replaced at the time the report is generated. Reports can be stored in SharePoint lists or return to user on the fly. At the moment there is no automated email sending functionality but i think you can achieve this using workflows in SharePoint.- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 06, 2009 6:03 AM
