Display list/library data using Data view web part (DVWP)

Add DVWP to web part page

  1. Open the site that contains the list/library that you need in SharePoint Designer.
  2. Navigate to “All Files”. Create a folder which will be used to store web part pages.
  3. Open the folder. Click “Web Part Page” button on the ribbon.
    1
  4. Choose one of the layouts. Enter a name. Notice the file is actually saved to Site Pages folder. So don’t panic if you don’t see it. Go to “Site Pages” from the left Navigation Pane and cut and paste the page to the folder you created in step 2.
    2
  5. Next, we are going to add the DVWP to the web part page. Click on one of the web part zones. Click “Insert” tab from ribbon->Data View->Empty Data View
  6. In the zone, click “click here to select datasource” to select the datasource or list.
    3
  7. From the “Data Source Picker”, select the interested List or Library.
  8. All the available fields of the selected list or library will be listed in the Data Source Details pane on the right side.
    4
  9. Drag the fields that you want to display to the web part.
  10. To add more columns or rows to the DVWP, click the Table tab on the ribbon and select relevant options.
  11. To add a horizontal rule, highlight the cell, the code will be highlighted in code view, enter <hr />. For example, <td colspan=”5″ /><hr/></tr>

Tips: For columns that displays raw html code, add disable-output-escaping=”yes” For example, <xsl:value-of select=”@Comments” disable-output-escaping=”yes”/>

Grouping, Sorting and Paging in DVWP

For grouping and sorting, click the web part and choose Options->Sort & Group in the ribbon.

5

For paging, click the web part and choose Options->Paging in the ribbon.

11

Filters and Parameters in DVWP

To filter on a column, simply click Filter.

6

To use a Query String, there are multiple steps as below.

  1. Click Options->Parameters->New Parameter. Select “Query String” from Parameter Source. Query String Variable is used in the URL, e.g. agdocs/stakeholder.aspx?ParaVar=ParaValue. Give a Default Value if you have one. Then click OK.
    7
  2. Go to Options->Filter. Choose the field that is based on the parameter value.
    8
  3. Save the page and open in browser. Items with Team value of Director & Support will be displayed as it’s the default value. In the URL, type ?Team=Portfolio Team to the end of the URL, items with Team value of Portfolio Team are displayed.
    9

Export Web Part

10

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s