SharePoint Web Parts
Our entire SharePoint web part listing.
Click on the Web Part to read a more detailed description
Data-Viewer Web Part - from Bamboo Solutions
Easily customize the look and feel of SharePoint Lists or SQL data in a grid style data view without using SharePoint Designer. Add flexible data grouping, sorting, filtering, and column ordering capabilities as well as show lookup list information in the same view.
What Does It Do?
The Bamboo Data-Viewer Web Part allows you to display list or SQL table data without creating a data view, within a Web Part without using SharePoint Designer. You can customize the look and feel, allow users to group, sort, and export items to Microsoft Excel, and customize the CSS or change the Web Part skin. It also provides powerful features such as displaying inline child list or SQL table data viewing and dynamic filtering on each column.
| Bamboo Data-Viewer Web Part vs. SharePoint Out-of-the-Box Functionality | MOSS 2007, WSS 3.0 | Bamboo Data-Viewer |
Display SharePoint List or SQL table data. |
 |
|
| Show child list or SQL data along with master data (linked through a lookup column or primary key) in a single view. | |
|
| Allow users to dynamically change the sorting and grouping. | |
|
| Set default grouping, sorting and filtering of the data in addition to allowing users to change these settings dynamically. | |
|
| 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. | |
|
| Allow users to perform inline, multi-level filtering of the data. | |
|
| Limit the number of items displayed at a time as well as the total number of items. | |
|
| Customize the CSS or choose a skin for the look and feel of the Web Part. | |
|
| Customize the translation of the Web Part tool pane text. | |
How Does It Work?
First, you must configure a data source: SharePoint List or SQL Server. Then you must select a master list (or table). The list (or table) selected act as the master when you choose to display inline child list or SQL 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. You can choose to display inline 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.
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.
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. If you want to continue to filter down the new data set, then enter another filter value in the same or another column. Export to
Excel: Export your data to Microsoft Excel by clicking the Export to Excel button.
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 edit the master or child item from the Web Part.
Why Did We Build It?
SharePoint users (MOSS and WSS 3.0) who want to display list or SQL data as a data view must use SharePoint Designer to create the data view and modify it to display the data with the look and feel, groupings, filtering, sorting, and conditional formatting of their choice. SharePoint Designer also has its own licensing cost in addition to most SharePoint administrators need to limit the use of this tool since users can modify SharePoint pages and data directly. The Bamboo Data Viewer Web Part allows you to benefit from the added control you have with creating data views of your data without having to create a SharePoint data view.
