9 august 2012 17:51
I have a data veiw web part that merges information from two lists. Since we upgraded to SharePoint 2010 the dropdown field filters only work intermittantly. By this I mean that most of the time when people click on the down arrow to select an entry to filter they see "This column type cannot be filtered" below the Ascending and Descenging options. Occasionally, and without reloading the page, the will see a list of unique field elements. I have noticed that I receive the error during the day when the server might be more heavily loaded whereas at night it tends to work more often, but still not always.
I haven't done anything fancy with the DVWP. It is pretty much out of the box with minimal formatting for some numeric values. Each of two lists are fairly sizable, but less than 1,000 items each. I need to keep the underlying lists seperate due to the sensitive nature of the data.
I appreciate any thoughts regarding how to fix this issue directly or how to get single view of two lists which works more reliably.
10 august 2012 11:17Moderator
20 august 2012 20:51
I can not reproduce the issue in my SP2010 environment. Do you have multiple web front end servers in SP2010 farm?
Also, please look into ULS log when you see "This column type cannot be filtered" in UI.
Jing Wang | Microsoft Online Community Support
27 martie 2013 04:35
I am having the same issue, I do have two front end web servers. SP 2010
I am using a SOAP web service to combine lists from multiple SharePoint sites.
Any advice would be appreciated.