Columns tab

!https://manula.r.sizr.io/large/user/1483/img/dv-display-xml.jpg!The Columns tab, consists of the Columns section. Use this section to select columns that should be displayed in the Data Viewer Web Part. Once you have configured the columns to be display, click on the Display tab to format the column data.

!By default, no columns are selected, therefore, you must select at least one column, otherwise when you save your Data Viewer Web Part configuration, an error message, Error occurred in Web Part is displayed with a description: Error occurred while trying to retrieve and display data.

At the top right of the Columns section, at least three icons are displayed, which when clicked allow you to:

• Update the Data Viewer Web Part with the columns selected.
  
  
• Add a calculated column
  
  
• Configure Advanced filtering.
  

Below these three links there are three icons, which allow you to:

• Select all columns.
  
  
• Invert the selection.
  
  
• Uncheck all columns.

The content of the rest of Columns section, may look different depending on the data source selected. For data sources such as SharePoint lists and library apps, SQL Server databases, Oracle databases, ODBC and OData data sources, the Columns section contains a list of columns, as described below:

• Selecting the check box to the left of the column name, to display data from that column in the Data Viewer Web Part. You can set the order of the columns within the Columns section, by dragging the columns up or down.
  
  

*When you have selected a SharePoint Library app as your data source and you want to show the name of the file, and want the name to become a link to the properties page or to open the file in the appropriate application, then select the Name column, which when you hover over it has the screen tip, LinkFileNoMenu, and then on the Display tab, complete the configuration options in the Linking and Grouping section.

• Filtering. You can filter the number of items return based on values in one column, by using the Filtering icon , or more columns by clicking the Advanced filtering link in the top right of the Columns section. Click the Remove All Filters icon , to remove all persistent filters from all columns.

The Display tab allows you to format, group, sort, align, and conditionally format the data from the columns you have selected, however, the Columns tab may provide other options within the Columns section dependant on the data source.

SQL Server data source

With SQL Server database tables the following options are available on the Columns tab:

• Group By Select the Group By check box to the right of the column to group items by that column. You can then select to aggregate each group by selecting the checkboxes:
  
  
  • Max
    
    
  • Min
    
    
  • Sum
    
    
  • AVG
    
    
  • Count
  
  
  Optionally you can select to format for numerical columns of each aggregated function using the drop down list to the right of each function check box.
  • 
    
    
• For numerical columns you can select, None, Currency, Decimal, Fixed Point, General, Hexadecimal, Number, Percent and Scientific.
  
  
• For Date/Time columns, you can select None, Long Date, Long Data and Time, Long Time, Short Date, Short Date and Time, Short Time and Year And Month. You can also type a custom date format.
  
  

OData data source

For an OData data source, the Columns section allows you to select the check boxes to specify the columns that are to appear on the Add New Item and Edit Item dialogs:

• Allow Insert
  
  
• Allow Update
  
  
  
  You must remember to select the appropriate check boxes in the Data Connection section on the Display tab for the Add New Item button and Edit icon to appear in the Data Viewer Web Part, so users can display the Add New Item and Edit Item dialogs.
  

*The presence of Allow Insert, Allow Update and the Data Connection check boxes do not indicate that the OData service allows users to complete insert or update operations. Once you have configured the Web Part, you should test the insert, update and delete operations, for error messages. If these operations are not valid then an error message is displayed, Error occurred in Web Part, with a description of The remote server returned an error (403) Forbidden.

XML data source

For a XML data source, in the Columns section:

1. For each column, in the Name text box, type the column name, and in the XPath text box type provide the XPATH expressions relative to the item tag you provided on the Data Source tab.
   
   
2. Click the green plus icon.
   
   
   
   
3. Select and arrange the columns and configure filters if needed.
   

Configuring the Data Viewer Web Part →