Share Point Reporting

Question

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 Share Point 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.

Answer 1

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.

Answer 2

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.