SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've created a bunch of Lists for users to enter data. Now it's time to start creating useful reports. All reports must be in SharePoint so we can't export to Excel or use SSRS. I created a SP-Report Center, now could someone plese help me create and link reports to the data the users enter in the lists? I do not have SharePoint Designer "yet" Thank you.

share|improve this question
Could you be a bit more specific as "reports" can mean a lot of different things. By default, the only reporting SharePoint has are the Views on individual lists. – Dave Wise Nov 2 '11 at 18:31
You can use Sharepoint lists as datasources in SSRS. – Eric Alexander Nov 2 '11 at 19:23
And then in turn display them back in SharePoint with either the report view web parts or via URL execution. – Eric Alexander Nov 2 '11 at 19:45

For SharePoint Foundation:

  • You can create Dashboard pages using WebPart Connections.
  • You can use ChartPart for SharePoint opensource project by Wictor Wilén to display charts based on lists information.
  • For displaying cross-list information, use Data View Web Part, and create cross-list datasources for it (SharePoint Designer has GUI for this).

For SharePoint Server, there are at least two additional great features. Yes, I've noticed the sharepoint-foundation tag, but just can't resist to mention :)

  • Excel Services will show Excel reports from within SharePoint portal, allowing users to perform some basic operations like filtering and sorting. And the Excel reports are stored in SharePoint libraries. So I reckon, Excel Services are a SharePoint-way solution too.
  • You can use Content Query Web Part to aggregate information from different lists.
share|improve this answer

My approach for ur query would be :

Complex and more in-detailed way of reporting:

  1. Use sharepoint list data source existing in sql server 2008 r2 and create SSRS or performance point based dashboards and reports

Simplest and OOTB based way of reporting:

  1. Use chart web part and display the content in different formats or use excel services to render the charts or dashboards via excel web access webpart.

  2. If not customize using sharepint desginer via dataview web parts or else right ur own queries leveraging linq with sp object model and display the dash boards\charts in user controls or web parts.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.