Solution Duplicate values in Filter selection



Filter in SharePoint Grid control not work properly , it display duplicate values.

Grid filters in SharePoint display duplicate values in drop down. there is no feature in SharePoint to correct this.


There is one good solution:

Open your page in SharePoint designer then edit in code view.

then find below string.


Locate the dvt.filterfield template in the Xsl and locate the following xsl:for-each statement:

<xsl:for-each select="msxsl:node-set($dvt_Rows)/*[not(@*[name()=$dvt_FieldNameNoAtSign]=preceding-sibling::*[1]/@*[name()=$dvt_FieldNameNoAtSign])]/@*[name()=$dvt_FieldNameNoAtSign]">

All I did to fix it was remove the [1], like this: 

<xsl:for-each select="msxsl:node-set($dvt_Rows)/*[not(@*[name()=$dvt_FieldNameNoAtSign]=preceding-sibling::*/@*[name()=$dvt_FieldNameNoAtSign])]/@*[name()=$dvt_FieldNameNoAtSign]">


Contact us on  kb@ebizassist.com 


We have highly technical, Microsoft Certified SharePoint Server consultants,

We are providing SharePoint assistance in:

  • Microsoft office SharePoint Server Training

  • SharePoint 2007 Training

  • SharePoint 2010 Training

  • SharePoint Migration

  • SharePoint Site Backup and Restore Tools

  • SharePoint Portal Services

  • SharePoint WorkFlow

  • SharePoint Server and Application Cost/License Analysis

  • SharePoint customized webparts

  • SharePoint Application Templates

  • SharePoint Document Management

  • SharePoint Project Management

  • SharePoint Portal Server

  • SharePoint Internal Database Structure

  • Integration with Quest

 Contact us at ask@ebizassist.com

The gadget spec URL could not be found


Comments