The Display tab is the last tab on the Data Viewer Web Part Configuration dialog. Use this tab to configure how the column data should be displayed by the Data Viewer App Part.

This section of the documentation describes how to use the Display tab when the GridView display provider is selected on the Web Part tab. Only those columns you selected on the Column tab are displayed in this tab.
Display tab

  • Display Format: Select from the Format list the format for the column, for example:
    • For a text column type, such as a Single line of text, you can select: None (default) or Hyperlink.
    • For a Boolean column type, you can select: None (default), Yes/No, True/False or Checkbox.
    • For numerical columns you can select, None (default), Currency, Decimal, Fixed Point, General, Hexadecimal, Number, Percent and Scientific.
    • For Date/Time columns, you can select None (default), 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.

    Display tab, column format


Alias: Most column names are not user friendly. In the Alias text box, type an alternate name for the column name.

Note: The column Name and Alias name are only displayed when the Show header check box is selected in the Header configuration section on the Display tab.

Column width: Type in the Width, px text box the width of the column in pixels.

Grouping: Select the Group By check box to group items by that column. If you wish to group using multiple columns, you can change the order of the grouping, using the Grouping and sorting section. Under Fields to group by drag columns in group order. The column at the top is the first column used to group the returned items.
Fields to group by
By default groups are expanded. To collapse groups when the Data Viewer App Part is first displayed, in the Grouping and sorting section, select Initially collapse groups checkbox. You can also display how many items are in a group by selecting Show count of items in groups check box in the Grouping and sorting section.

Show: You can select whether to show column values. When you use the Group By check box for a column, you many not wish to display the column as values from the column are they are displayed in the group heading.

Column Alignment. From the Align list, select, Not set (default), Left, Center, Right, or Justify.

Bold, Italic, Underline check boxes.

Foreground and Background colors

Conditional Formatting. Conditional formatting can be set per value or per row allowing you to change formatting options only if a condition is true, for example, you could highlight any Products that have a Units in Stock less than 10 or Tasks assigned to you. Click the formatting icon Format icon to display the Configure Conditional Formatting dialog. Under the Formatting, click the Remove all conditional formatting icon Click to remove all formating from all columns to remove conditional formatting from all columns. Click the Remove icon Click to remove all formating from all columns to the right of the formatting icon Format icon to remove formatting from a column. See the Conditional Formatting section in this documentation for more information.

Summarizing data. Column values can be summarised, for example, counting the number tasks displayed within the app part. Click the summary Sum icon icon to display the Configure Summary Functions dialog. Under Summary, click the Remove all summary functions icon Click to remove all formating from all columns , to remove all summary configuration from all columns. Click the Remove summary functions icon Click to remove all formating from all columns to the right of the summary Sum icon icon to remove the summary configuration from a column. For more information, see the Summarizing data section in this documentation.

Header Configuration, Data Connection, Grouping and Sorting, Paging Settings, Summary rows and Messages are covered in subsequent topics.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment