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.
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:
- http://www.the-north.com/sharepoint/post/Further-Customise-CQWP-to-Display-Draft-and-Checked-Out-Pages-By-User.aspx
- http://www.the-north.com/sharepoint/post/Embed-CAML-Queries-into-the-Content-Query-Webpart—Finding-Draft-Publishing-Content.aspx
- http://www.heathersolomon.com/blog/articles/customitemstyle.aspx
- 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…
aanuwizard.com 
I am just so greatful for all the effort you put into helping me solve this issue. May the best karma be bestowed upon thee!
Guys guys guys…..
Go to Site Settings…Manage content and structure….
In the default view that lists all documents select the view Checked Out to Me.
Regards!
I don’t have access to many of these features — but here’s what I did to find out what documents are checked out.
1. Create a view that includes the column “Checked Out To”
2. Click on “Actions” -> “Export to Spreadsheet”. When prompted, save the file.
3. By default, a file called owssvr.iqy was created
4. Double-click the file, click through the security warning, view data in a table and a new workbook (or whatever) and click ok.
5. Voila – the data is in Excel and you can filter, sort, etc. to see who has items checked out.
euh – Checked Out To Not Equal to and you are done. Alle checked out documents
This is the correct and easiest solution…
This is great and works well for the current user that is signed in. How do you set it up to get all users Checked Out To documents. Or the Draft documents because they have never been checked in?
Will this work across an entire site collection? That is what I really want, not just for a site and its subsites but top down, every page I’ve touched that is still checked out.