SharePoint 2010: get All checked out documents report with checkedOut column

Problem:


How to achieve a report to retrieve All checked out documents in site collection with Checked out column.
I hope this help you to understand choosing right approach to solve your problem.

Workaround:

Content and Structure Reports
Lets start with what SharePoint gives in-Built option – Content and Structure Reports.
These are really good, ready to use reports. You can customize the filter condition here but no option to customize the report columns.
Checked Out To Not Equal to and you are done for getting all checked out documents.
But if you need to choose the ‘checked out to whom’, then this will not work.
SSRS
Lets look at to SSRS (SQL SERVER Reporting Service) with SharePoint :
You will get full customization for filter condition and report columns also.
But it is limited to one list/library. So this will also not work for our problem.
Content Query Web Part
Content query web part is the right choice for this problem.
Few reference to start with this:
  1. http://www.the-north.com/sharepoint/post/Further-Customise-CQWP-to-Display-Draft-and-Checked-Out-Pages-By-User.aspx
  2. http://www.the-north.com/sharepoint/post/Embed-CAML-Queries-into-the-Content-Query-Webpart—Finding-Draft-Publishing-Content.aspx
  3. http://www.heathersolomon.com/blog/articles/customitemstyle.aspx
  4. http://blogs.msdn.com/b/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx
Your Custom webPart
This will give you full control to everything.
To solve our problem you will need to use SPSiteDataQuery.

Hope that helps…