Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

About Connecting a List View Web Part

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

The List View Web Part has two different tabular views: Standard view, which is available to any user, and Datasheet view, which is an Office Excel-like spreadsheet that uses the Microsoft Office List Datasheet Component and requires Microsoft installed on your client computer.

Using either Standard or Datasheet view, you can connect a List View Web Part to another Web Part, provide data to it, and change the way data is displayed in the other Web Part, including another List View Web Part. The following connection type commands on the Connections submenu of the Web Part menu are available:

Provide Row To

You can connect the List View Web Part to another Web Part by passing a selected row of data to the other Web Part. Depending on how the other Web Part was created and gets the data, it might display the row data or use it as a filter or parameter value.

In Standard view, a Select Item column containing option buttons is automatically added when you connect the List View Web Part, so you can indicate which row to pass to the other Web Part. You can only select one row at a time in Standard view. Some columns, such as the Edit column, are not available for use in a Web Part connection.

In Datasheet view, you can select multiple rows, but only one row is passed to the other Web Part. If multiple rows are selected, the row containing the active cell is passed to the other Web Part, and all other rows are ignored. You cannot provide data in the Total row or New row to the other Web Part.

You can have more than one Web Part connected with this type of connection to the List View Web Part.

Provide View Data To

You can connect the List View Web Part to another Web Part that works with list data.In this case, the List View Web Part is the data source for the other Web Part.

In Standard and Datasheet view, only the data in the view is provided to the other Web Part.

You can have more than one Web Part connected with this type of connection to the List View Web Part.

Get Sort/Filter From

In Standard and Datasheet view, you can connect the List View Web Part to another Web Part that can provide the following information to it:

  • One or more column name and value pairs of data that filter data in the List View Web Part.

  • A column of data to sort data by either ascending or descending order in the List View Web Part.

Only one other Web Part can be connected with this type of connection to the List View Web Part.

About supported list types that can be connected

Although you can display all list types in a List View Web Part, only certain list types are supported when making a Web Part connection. In general, list types that display data in tabular format, such as Contacts, are supported. Lists that display data in a non-tabular format, such as Folder view, are not supported.

Supported list types in a Web Part connection

Supported list types include the following:

  • Announcements

  • Contacts

  • Events

  • Links

  • Tasks

  • Custom Lists

  • Lists that contain data imported from a spreadsheet

  • Document Libraries

  • Form Libraries

Unsupported list types in a Web Part connection

Unsupported list types include the following:

  • Calendar view of an Events list

  • Discussion Boards

  • Issues

  • Surveys

  • Picture Libraries

  • Site and List Template Catalogs

  • Web Part Galleries

  • Data Sources

About supported list column types that can be connected

Although you can display all list column types in a List View Web Part, only certain list column types are supported when making a Web Part connection.

Supported list column types in a List View Web Part connection

Supported list column types include the following:

  • Single line of text

  • Choice

  • Number

  • Currency

  • Date and Time

  • Hyperlink or Picture (for matching columns)

  • Lookup

  • Yes/No

  • Calculated

Unsupported list column types in a Web Part connection

Unsupported list column types include the following:

  • Hyperlink or Picture (for filtering)

  • Mutiple Lines of Text

  • Edit

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft