Are you looking to display data from a SharePoint list/library, SQL table/view, Bamboo List Rollup, or BDC/BCS without the need for creating a data view that requires SharePoint Designer?  With Bamboo’s Data-Viewer Web Part, you can accomplish all of this and more. Whether you want to: customize the look and feel; allow users to group, filter, and sort; apply calculations and/or export items to Microsoft Excel; or customize the CSS, Data-Viewer Web Part is THE must-have tool for business intelligence and analytics. All these options, as well as the ability to: perform inline editing of data; apply conditional formatting and calculations to both the master data and the nested child data; and access Lists and List Rollup data-views from all across your SharePoint farm, are all available now with the latest release of Data-Viewer Web Part. Here in part one, we’ll show you how to configure the Column Display Settings.

To help celebrate the release of Data-Viewer Web Part version 3.6, we have put together a brand-new 8-part series that will walk you through how to use the product’s newest and most popular features. Let us show you how to configure the Column Display Settings.

For version 3.6, we’ve made some beneficial changes to the Column Display Settings that will help you maximize the ways in which you view your data. These updates include:

Justification

You can now indicate whether you want your data Right or Left justified:

Column Width

By selecting the Set Custom Column Width checkbox, you are able to customize your Column Width. Simply enter your desired width (in pixels) in the respective column:

Additionally, you can resize columns by selecting the Allow columns to be resized checkbox in Data-Viewer Web Part Settings:

To resize columns manually, simply grab the edge of the column and, similar to columns in Microsoft Excel, drag the column to your desired width:

Column Position

You are now able to indicate where you would like each of your columns to be positioned in Data-Viewer Web Part

Column Alias

Further, customize your columns by renaming them with a label of your choosing:

Are you ready to test drive Data-Viewer Web Part in your own SharePoint environment? Jump over to the Data-Viewer Web Part product page now!

Want to learn more about Data-Viewer Web Part? Check out the rest of the series here:

• Part 2: How to Create and Display List Data Calculations
• Part 3: How to Use the Print Feature
• Part 4: How to Create a New Item in a Parent List and Nested List
• Part 5: How to Group, Sort, and Filter List Rollup Data
• Part 6: How to Update the Skin and Font to the Site Theme
• Part 7: How to View Lists Flat and Lists in Folders
• Part 8: How to Define Column Headers