SharePoint Data View Web Part – Edit & View List Data in Grid View

Easily customize the look and feel of SharePoint List, SQL, List Rollup, or other external data in a grid-style data view without using SharePoint Designer.

Customers with a Bamboo Ultimate Suite or Bamboo Project Management Suite premium support contract can get this product free as part of your support subscription.

See what other users are saying about Data-Viewer.

Check out the Bamboo Knowledge Base

Working for a U.S. Government agency or on behalf of one? See our Section 508 Compliance page for information regarding Bamboo product accessibility.

Eliminate user requests for data views and save some money at the same time.

The Bamboo Data-Viewer Web Part displays SharePoint list/library, SQL table/view, Bamboo List Rollup or Business Data Catalog data without the need for creating a data view which requires the purchase of SharePoint Designer. Like the data views you can create with SharePoint Designer, you can allow dynamic grouping, filtering and sorting, exporting items to Microsoft Excel, and customizing the CSS or changing the Web Part skin. In addition, you can display nested child SharePoint list, SQL table/view, or List Rollup data. You can also perform inline editing of data, including SQL and List Rollup, apply conditional formatting and calculations to both the master data and the nested child data, and -- with proper permissions -- access Lists and List Rollup data-views from all across your SharePoint farm!

Bamboo Data-Viewer Web Part

Here are just some of the things you can do with the Data-Viewer Web Part: Now supported on SharePoint Foundation 2010 and SharePoint Server 2010. New! Display SharePoint List, SQL table or view, List Rollup data view/form data. Access data from across site collections. Show your external data via the Business Data Catalog in the Data-Viewer Web Part using MashPoint. Show child list, SQL, or List Rollup data along with master data in a single view. Allow inline editing of SP List, SQL, or Bamboo List Rollup data directly from the Web Part interface. Apply conditional formatting to master data and nested data separately. Perform a calculation (sum, average, count, min or max) on selected columns in the parent and child data sets. Set default grouping, sorting and filtering of the data, or allowing users to change these settings on the fly. Sort data in both the parent and child data sets separately. Users can drag and drop column headings on the grouping bar in the Web Part to dynamically group the data. Export data to Microsoft Excel. Exporting data to Microsoft Excel exports parent and child data into separate sheets. Allow users to perform inline, multi-level filtering of the data on the entire data set instead of just each page in the list. Limit the number of items displayed at a time as well as the total number of items. Customize the CSS or choose one of 12 different skins for the look and feel of the Web Part. Customize the translation of the Web Part tool pane text. Works with the new Bamboo Web License Manager 1.2. Add new items directly from the Data Viewer Web Part when connected to a SharePoint List or Library.
SharePoint Administrators can now offer the ability to view SQL, Bamboo List Rollup, Business Data Catalog (BDC) or MashPoint data in SharePoint through a customizable, data view-like interface without having users purchase SharePoint Designer to create a data view. This also eliminates the chance of users potentially creating more issues with their ability to modify SharePoint pages using SharePoint Designer, resulting in less support calls from end users as well as providing them valuable functionality that increases productivity and communication. For organizations who want to connect their existing line of business data to their SharePoint users, corporate SharePoint Administrators can easily create data views for SQL data, SharePoint Lists, Bamboo List Rollup data views/forms or any external data source accessed via the BDC allowing SharePoint users to work with data in a familiar environment and with familiar applications (i.e. Microsoft Excel). Department Site Administrators who want to provide data views to their users quickly no longer need to request special software from IT Administrators to create those data views saving time and money.
First, you must configure a data source: SharePoint List, SQL Server, List Rollup data view/form, or MashPoint/BDC. Then you must select a master list (or table/view, data view/form, or entity data). The list selected is the master list when you choose to display inline child list, SQL data, List Rollup data or MashPoint/BDC data in the Web Part. Then select the columns you want displayed in the Web Part. Optionally, you can set the default grouping, filtering and sorting that users see when they first view the data. You can also configure the Web Part to allow users to dynamically change these settings. Set conditional formatting on the master and/or child data in the Web Part. Set the font color, size, weight, etc. Apply calculations, such as sum, count, average, min or max, with labels and formatting to parent and child columns of your choice. In addition, you can allow users to edit master data inline, directly from the Web Part (does not apply to MashPoint/BDC data). You can choose to display a nested child list or SQL data that users can view by expanding a node on the master data row in the Web Part. Select the columns you want displayed in the child view as well. Then set the item limits and language setting. Finally, you can choose to customize the CSS directly, or select a skin. Depending on the options you choose, users can do the following in the Web Part: Group By: Drag and drop column headings to the bar at the top of the Web Part to group the data. Drag as many columns as you want to display sub-groups of data. Sort: Click the column headings to sort ascending, descending, or not sort at all. Sort master and nested child data separately. Filter: Filter the data by entering a value in the filter text box displayed at the top of each column. Enter the filter value for one column, then click the Filter icon. Select from a list of comparison operators, such as equal to, contains, starts with, etc. Export to Excel: Export your parent and child data to Microsoft Excel separately by clicking the respective export button. Inline Edit: Click the Bamboo Edit icon to edit your master data (SP List or List Rollup) directly within the Web Part interface. Add New Item: Click the Add New Item link at the bottom left of the Data-Viewer Web Part to enter in new item information in a pop-up form for SharePoint List and Library data sources. Nested Data: Users can expand the node to view nested child data. If the Web Part is configured for a SharePoint List, then you can choose to display the Title column with link to the item and/or the Edit icon in the master list (if you've added it to your list view). You can also choose this Title column type to display in the child list data. Users can click the Title link (or the Edit icon) to go to the Edit form for the master or child item from the Web Part. Conditional Formatting: Configure the Web Part to format column cells or entire rows of data based on the value of a specified column. You can conditionally format the master data as well as the nested child data. Calculations: Configure the Web Part to label, format and apply a sum, average, count, min or max calculation on master and/or nested child column values.