We help IT Professionals succeed at work.

Running Reports From SharePoint 2010 Document Library

Lord_Dragon
Lord_Dragon asked
on
Is there an Out of the Box (OTB) way to run or create reports from a SharePoint 2010 Document Library? This would need to be done without using any code solutions and without SharePoint Designer.
Comment
Watch Question

Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
could you please explain what you mean with "run / create a report"?

You can install SQL Server Reporting services in SharePoint integrated mode. Then you will get new library types and content types and then you can create reports using the report builder or deploy reports from BIDS/SSDT. These reports can then be run / opened from the library or shown on web part pages using the Report Viewer web part.
HTH
Rainer

Author

Commented:
My apologies, it isn't a Library but a List. Would like to be able to generate a report based on the data contained in the various columns of the list.

I would need to be able to do this strictly using features that are already within SharePoint. Not Designer, not code, not installing any 3rd party applications.
Most Valuable Expert 2013
Awarded 2012
Commented:
Sorry, I still do not get it.
A report (in my point of view) is also code. SQL Server Reporting Services are part of SQL Server and as SharePoint needs a SQL Server also part of OOTB functionality.
You might try to grab the list data into Excel (Excel should has a SharePoint list connector letting SharePoint list serve as data source) and then build the report inside Excel.
Everything else is e.g. using JavaScript and SharePoint client object model to grab the data and display it somehow on a SharePoint page.
Or you simply create a SharePoint view with all the limitations it has.
I assume that building a custom XSLT for using a standard SharePoint web part would also be "code" in your situation?

Sorry, but that is a ridiculous situation - someone wants to have something but you should not use anything that can do the job.
HTH
Rainer

Author

Commented:
Ok, perhaps it isn't possible to do without the methods you're describing and if so then that is fine. However that may not be the case. If you don't mind, let someone else respond to this inquiry.

Author

Commented:
Thank you sir, your input was greatly appreciated but not the remedy I sought. There was however a way to do what I was asking, fortunately.
Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
thanks for the points. Could you perhaps share your solution?
Thanks and KR
Rainer