Publishing Sites: Content and Structure Reports Not Showing
I recently attempted, and mostly succeeded in exporting a complete Publishing site collection from a development environment into Production. I had many problems and issues with the whole process, but eventually got it up and working after rebuilding most of the approval workflows by hand.
One of the items I missed until accidentally stumbling upon it was the following: View Reports in Site Actions, or "Views" in Content and Structure were doing nothing. The page would load, no errors were seen, and yet no data was ever displayed.
After significant and fruitless searching, I came across Marc's blog here. Marc hit the nail on the head and this turned out to be my exact problem.
The SPWeb object contains a property (in AllProperties) called _SmtReportsListId. This property contains a GUID that points to the Reports List. This is a hidden list called Content and Structure Reports that contains those individual reports you are accustomed to seeing in the Content and Structure views (Checked Out to Me, Pending Approval, etc.)
When I imported the site collection, the _SmtReportsListId GUID was still pointing at the old list from development. This may be due to my need for fiddling with the publishing settings in order to get the import to work.
In order to fix this problem, this GUID needs to be set to the new (local) correct Content and Structure Reports list found at the root of your site collection.
This was accomplished using a small console application Marc wrote. It can be found in the link to his blog. In order to figure out the GUID of the list I needed to point to, I used the very handy program "SharePoint Manager 2007" which can be found here.
I hope this helps,
-Ryan