StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>In addition to SSRS you should also consider using either Excel or Access to run reports :-</p> <p><a href="http://technet.microsoft.com/en-us/magazine/2009.02.bookbi.aspx#id0060016" rel="nofollow noreferrer">Analysing SharePoint Data in Excel</a> (Look for the section titled SharePoint-to-Excel and Data Synchronization)</p> <p><a href="http://sharepoint.microsoft.com/_layouts/error.aspx?aspxerrorpath=/blogs/GetThePoint/Lists/Posts/Post.aspx" rel="nofollow noreferrer">How to Link SharePoint Server 2007 Lists with Microsoft Access 2007</a></p> <p>Page currently borked, cached version <a href="http://209.85.229.132/search?q=cache:YnuTwWha77UJ:sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx%3FID%3D68+connecting+access+to+sharepoint+lists&cd=5&hl=en&ct=clnk" rel="nofollow noreferrer">http://209.85.229.132/search?q=cache:YnuTwWha77UJ:sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx%3FID%3D68+connecting+access+to+sharepoint+lists&cd=5&hl=en&ct=clnk</a></p> <p>Remember that you can also access the list data as XML so any 3rd party BI/reporting tool that can call one of <a href="http://www.csharphelp.com/archives4/archive602.html" rel="nofollow noreferrer">SharePoints web services</a> and manipulate the resulting XML could also be used - there are must be hundreds of contenders here.</p> <p>The best tool to use depends upon many factors such as what you may be familiar with, the complexity of analysis you need, if you need static or dynamic reports (drill down etc). BI & Reporting tools are a <em>huge</em> area!</p> <p>Finally if you need fairly simple PivotTable/crosstab type functionality then this <a href="http://www.pentalogic.net/crosstab-for-sharepoint.aspx" rel="nofollow noreferrer">CrossTab web part</a> may be suitable (<em>disclaimer - its sold by my company</em>)</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload