.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Content and Structure Report not showing all items

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
I have an environment where the Site Owner is not seeing all items pending approval when they access that view from the root node in the Content And Structure section.

We can see pending items in this view if they access some of the lower level nodes in the tree structure, just not from the top node.

I've noticed that the second level nodes are not inheriting permissions from the root node, but I'm not sure if that is relevant. I've also checked the CAML for the Pending Approval view and it has not been altered in any way.

Any ideas?

View Complete Post

More Related Resource Links

View All Site Content Showing the wrong number of items

NOTE:  Similar post also had no answer: http://social.msdn.microsoft.com/Forums/en-US/sharepointecm/thread/f775ba0d-648f-4be3-9017-78539915b281/ I am the Site Collection Administrator/and also tried logging in using Farm Account.  I go into View All Site Content and I show 15 documents.  When you actually go to the All Items view (and I double-checked, no filtering), you only find 9 documents.  Versioning is not turned on.  I am a developer, so I also used the Web Service to try to troubleshoot.  The Lists.asmx web service shows an Item Count of 15 using the GetList method.  However, using the GetListItems method, the item Count reports 9 items, which is what I see in my browser. Is there an stsadm command that I can run that will "true up" this number being reported in View All Site Content? Thanks in advance. - Update -  MOSS 2007 v 3.0 server farm.

Showing filtered Records in Crystal Report as per User Requirement


ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            CrystalReportViewer1.ParameterFieldInfo = paramFields;

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

How to Customize the Add Comment 'Items on this list require content approval...' notification in


WSS 3.0:

If content approval is turned on, the Add Comment section displays a fairly ugly notification. Is there any way I can customize that section through e.g. CSS or SPDesigner?

I'd like to change at least the text, and preferably the yellow exclamation image, and also the background if possible.

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

SharePoint 2010 Search Service Application: "All Content" scope contains 0 items?

I've encountered a nasty bug in our setup. Our Search Service Application manages to crawl all content just fine. However, the scopes don't work. We've got a total of 570 items currently in our crawl database. 350 of these are of class 'People', and appear in the 'People' scope. The remaining 220 items should appear in 'All Content' as part of the intra (sites, documents etc), however the 'All Content' scope reports 0 items. I've tried the following: -Creating custom scopes (still 0 items) -Recreating the Search Service Application twice -Tried different accounts as the content access account. -Ensuring that the content access accounts do have 'full read policy' -Checked the crawl log for successful content (such as sites and documents). However, despite my efforts I still get 0 items for 'All Content'.  Has anyone else encountered this problem, or do you have any recommendation for us? Currently I don't see any other option than to reinstall everything.

Repeating table not showing content following a rule refresh

Background info: I have a form where I populate employee info from the GetUserProfileByName ws. From there I populate its manager info from another web service call (seperate data connections).  Once the manager is populated, through rules, I'm populating the first approver. All this is done at form load through rules. The approvers node is defined as follows and is displayed on the form as a repeating table:  participants (group)    approver (repeating group)       ApproverName       ApproverLogin       ApproverEmail Problem: The repeating table is not showing any content even though I'm using an alert to show that I do in fact have one row in there. As a side note, I know the table is working because if the user elects to delegate approval to another user (through the people picker), the table shows these approvers correctly.  Anyone as any clue what I'm doing wrong? Thanks!    

Need to link multiple External Content List items to a single document metadata column

I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint. Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata. Any ideas for how I can make this work?

LS Status Report showing false alert state

I have log shipping every 15 minutes working between 2 servers, and while the secondary server reports everything ok (time since last copy, restore are all under 15 minutes), the primary server reports that the time since last backup is 7400+ minutes.  I have verified that the LS backup job has no failures.  How can I correct this false error state and get the primary server to start reporting actual statuses?   The LS monitor is on the secondary server.

showing number of items in sub folder

Hi, In "All Site Content", we can see the number of items under each folder. But when we open the folder for example Documents, if it has sub folders, there it does not list the number of items. How to list the number of items in the sub folders. Thank you

Content Query Web Part (CQWP) fails to show picture items from a document/picture library in an anon

I have a Picture Library and am trying to use the CQWP to display a list of items in the library.  The web part shows the items fine in authenticated mode, but it fails to show the items to anonymous users. The error log message is: Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.SetDocumentIconUrlAndOnClickString(SPWeb web, DataRow row, String strDefaultItemOpen, Boolean fSetDocIcon, Boolean fSetOnClick, String fileRefColumnRef, String progIdColumnRef, String fsobjTypeColumnRef, String permMaskColumnRef)     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.PreProcessForDocumentIconAndOnClickAttribute()     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.AddContentQueryData()     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.GetXPathNavigator(String viewPath)     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) I'm running SP 2010.  I've tried various scenarios including: 1. Using the default publishing template. 2. Using the blank site template with publishing and lock down features enabled. 3. Us

Content and Structure reports

Hello, I have 4 production sites that I work on.  1 of these sites uses content deployment to the other 3 sites to keep the top page and navigation in sync between the 4 sites. We a sort of different from the norm, where content deployment is used for test -> production. At the global site I have created a content and structure report that shows only a users incomplete tasks.  I wrote the caml on a different system and got it running on a dev system, then copied the query to production.  Thing is that the query works everywhere except the one global site that content deploys to all other sites.  If the query were broken then it wouldn't work at the other sites, but it does so I don't think it is the caml query.  Just in case I have included it below. <Where><Or><And><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="int"><UserID /></Value></Eq><Neq><FieldRef Name="Status"></FieldRef><Value Type="Text">Completed</Value></Neq></And><And><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership><Neq><FieldRef Name="Status"></FieldRef><Value Type="Text">Completed</Value></Neq>

Folder inside the List shows Access Denied when try to open using Manage Content Structure

Hi All, We are facing this issue in one of our site, when accessing the folder from Manage content structure. Folder is inside a list which uses a folder content type. When we try to open this folder use manage content and structure it throws access denied. any idea how we can check this as we the permissions are properly inherited and all the folders are checked in . Please update what else we can check.   Thanks, Jasjeet SIngh

Convert Xml content from a Dataset to another Dataset for SSRS report?

Hi All Does anybody know how to convert xml field from SQL Query to Dataset? For example I have a table T with Fields A(VARCHAR), B(INT), & C(XML). Field C has <test><row>ROW 1</row><row>ROW 2</row></test> I make a query to get this data and call this Dataset1 Now I want the Column C content to be converted into a dataset  call it Dataset2 so that I can drag and drop tables from there to make my reports. Is it possible to do it without using webservice?Another limitation I have, I should not have to connect to DB again, so this boils down to use the already data contained in Dataset1. I was trying to somehow embed this XML content in the query at runtime dynamically? I am currently looking for a way to use the Dataset1 as the datasource and and parse the XML content of Dataset1 to Dataset2. Also, is it that XML content needs to hardcoded in the query, can't we do it dynamically and run the query?

How to show the content of two tables in one report?


Hi there,

I am working with reporting services for the first time and I have a very basic question, but can't find a solution for it anywhere. I use Visual Studio 2008 and SQL Server 2005.

Here is the problem:

I have two SQL data tables, one consisting of general data about a person (name, age,..) and one containing their employment data (joining date, salary, ...). I now want to show both tables for one particular person in one report such that the general data as well as the employment data each have their own section, such as


Name: Thomas Mueller

Age: 27

Activity feed not showing tag items...



I'm trying to get activity feed to show items that I've tagged. Its not showing up on my colleagues' newsfeeds. The news feeds are only showing profile changes... Any idea why?

Move page in Site Content and Structure alters revision history and makes old content available


This sounds bizzare, I tried it on an OOTB publishing site.

I have a page X in site A. Page X has version 1.0 and 2.0 approved and published, no minor versions anywhere. I choose to move page X to site B. Page X now has revision history version 1.0 (published and available) and version 1.1, which is exactly the same as version 2.0 but no longer visible to the outside world.

So the first problem is that moving a page makes a previously published and overwritten version of the page content available again. If I publish the page it goes to version 2.0, but I have to remember to do this. Also because I approve the page, my user id is associated with the publication of the content (which is sorta ok) but the original author of version 2.0 has now presumably been lost to the ether ... or the green swirling icon of death.

But I don't publish page X because I think "oops I meant to move page Y" and move it back to site A, without first publishing version 1.1. Now I have version 0.1 and 0.2. 0.1 matches the original version 1.0, and version 0.2 matches the original version 2.0, however the best bit is that the timestamps are such that version 0.1 is now checked in after version 0.2.

I then publish the page, I now have version 0.1 and 1.0, where 0.1 matches the original version

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend