Dropdown field filters work intermittantly in DVWP

Question

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.

This seems like some sort of timeout issue with a javascript based web service call, but I haven't been able to find any way to tune the timing.  I also noticed that the filter list works more reliably in Firefox and Chrome than Internet Explorer 8 which may indicate that the timeout is occuring on the client side.

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.

Answer 1

Hi,

Thank you for your post.
I'm trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thanks ,
Entan Ming

---

Entan Ming

TechNet Community Support

Answer 2

Hello,

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.

Regards,

Jing Wang | Microsoft Online Community Support

Answer 3

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.