Tuesday, June 14, 2011

Filter data in a DataView Web Part using SharePoint Designer

Follow the steps to filter the Overall Project Status by its Status, Assume that we need to list all the project that are in open status.

  1. Open the page that contains the Data View that you want to filter.
  2. Right-click the Data View, and then click Show Common Control Tasks on the shortcut menu.
  1. In the Common Data View Tasks list, click Filter.
  2. In the Filter Criteria dialog box, click Click here to add a new clause.
  3. Select more fields from Field Name drop downFilter in DataView WebPart
  4. Select the field Status field and Click Ok
  5. Enter the value as Open in the Value field and click OK
  6. Apply Filter in DataView WebPart
  7. Save the file and refresh the page to verify the webpart.


  1. This is a really good read for me. Must admit that you are one of the best bloggers I ever saw. Thanks for posting this useful article.

  2. Great blog. Actually i was searching for a blog or any article related to this. Thanks for sharing.