> Listview functions

Listview functions

You display the sub menu of listview functions by pressing Ctrl+F1, or right-clicking in the header row of any listview.

Listview functions

Field Description
Mini Toolbar Displayed above or below the listview sub menu, this enables you to:
  • Increase/Decrease the listview font size
  • Expand/Collapse groups
  • Change the background and foreground colors
  • Call up the Find function (listview only)
  • Filter text (listview only)

  • Filter columns (listview only)

  • Apply a new font or theme (listview only)

  • Modify how data is visualized in a cell by using the XAML markup code feature (listview only)
Export/Print  
Print Prints the contents of the columns currently displayed in the listview to a Windows printer.

Depending on the print layout defined (see Print Page Setup), some columns are automatically reduced in width to fit the listview on the page.

Print Page Setup Defines the page setup options for printing the listview, including paper size, orientation, margins, headers and footers, etc.
Print Preview Preview the listview on the screen before printing it.
Print Columns across Multiple Pages

Prints all columns in the listview over multiple pages, using the column heading width displayed.
Print Page Border

Select this to print the page border on each report page.

This option will affect the performance when printing the report.
Email Report Emails the contents of the listview to an email recipient as an HTML attachment.

You will need to indicate an e-mail address of the recipient. Entry of a subject line and additional text is optional.
Export as HTML Generates an HTML file (name of the operator with an .HTM extension) containing the contents of the listview in the Base\Samples folder.
Export as XML

Generates an XML file containing the contents of the listview.

You need to enter the name for the XML element that will contain the detail records, and the name and location for the file. A stylesheet is created with the same name, but with an .XSL extension.
Export to Excel

Exports the listview to Excel as an HTML file which can be edited using normal Excel commands.

All values from alphanumeric fields are treated as text values in Excel.

Export to Excel (CCYYMMDD) Exports the contents of a grid-style listview to Excel, but forces all date values to be output in CCYY-MM-DD format.

This addresses an issue where SYSPRO is unable to correctly interpret date cells pasted back into a grid-style listview that do not conform to this format (e.g. 28 June 2016).
Export as Excel Chart Exports the listview into Excel as an Excel chart (i.e. a graph).

At least one column containing numeric data must exist in the listview for the chart to be created.

You will need to indicate the X-axis and Y-axis of the chart and also the type of chart you require.
Copy Selected Records Copies the row(s) currently highlighted in the listview to another application (e.g. Excel).
Multiple Row Selection Exports selected listview rows to a third party application such as Excel.

You can use the Ctrl key (together with your mouse pointer) to indicate the rows you want to export. You can then select Ctrl+C or the Copy Selected Records option to copy the rows into the third party application (e.g. Excel).
Paste (all columns) Ensure that you have data for all the columns that can appear in the data grid before selecting this option.

When you select to Paste (all columns) the date you are pasting must be in the format CCYYMMDD. The date is not converted into your SYSPRO date format.
Paste (visible columns only) (Applicable to data grids) This makes it easier to create an Excel spreadsheet of columns suitable for pasting into a data grid.

You can export the current listview to Excel and, using the same columns shown in Excel, paste them back directly into the same listview. This prevents you having to sequence the columns in Excel according to the listview's original column sequence.
Duplicate  
Customize  
Show Listview Toolbar Displays the built-in toolbar for the listview (if applicable).
[Note]

  • You cannot deselect this option when the Show built-in toolbar option is enabled in the System-wide Personalization program.

  • You cannot deselect this option when the toolbar contains any buttons which are predefined by SYSPRO developers.

  • The Refresh button is not displayed on the toolbar for Associated panes (these are linked to a key field and are automatically refreshed when the key field changes).

  • This option saved at operator level, which means that even if it is set at Role level in Design mode, the operator can override it.
Macro for This indicates the macro for the listview. This uses the VBScript Editor program to add events for the current field or for the entire listview.
Add Custom Columns

This enables you to retrieve custom form fields (or blank fields populated with VBScript) for display in a listview. This applies to standard listviews as well as listviews in customized panes.

This option is only available if:

  • The SYSPRO company is configured to use SQL Server for data storage

    In a C-ISAM environment you will only be able to add blank columns to a listview. In addition, if you already have custom columns added to a listview, then these columns will not be populated with data.

  • The option to store the custom form field information separately for each custom form has been selected (SYSPRO Ribbon bar->Administration->Custom Forms)

  • None of the columns defined in the listview are configured to be editable.

When adding a custom column to a listview, the column is only populated with data when the listview is refreshed. This could entail closing the program and opening it again.
Column Headers Removes/reinstates column headings for the listview.

You can also restore headings using the Ctrl+Shift+V key combination.
Grid Line Style

The color and style you require for horizontal and vertical grid lines.
Text Color The color in which you want to display the data within the listview.
Background Color The color in which you want to display the background behind the data within the listview.
Row Font The font and font size in which you want to display the data within the listview.
Caption Text Color The color in which you want to display the column headings in the listview.
Caption Font The font type and size in which you want to display the column headings in the listview.
Footer Background Color The color in which you want to display the background behind the text for the column headings in the listview.
Shade Group Headings Displays group heading rows as shaded for heading rows created when you use the Group By This Field or Group by Box options to group the data within the listview.
Bold Group Headings Displays group heading text in bold for heading rows created when you use the Group By This Field or Group by Box options to group the data within the listview.
Select Styles

For listviews that have been designed to cater for styles, you can view the listview items to which styles can be applied.
Apply Styles Applies the style defined using the Select Styles option to the listview.
Alternating Row Color Shades each alternate row in the listview in a specific color.
Remove Alternating Row Color If you have set alternate rows to a different color, then this removes the shading.
Watermark file  
Freeze Columns

Lock up to five of the leftmost listview columns in position. Once locked, the (frozen) columns remain visible when you use the horizontal scroll bar at the bottom of the listview.

Note that the actual number of columns displayed as frozen in a listview is affected by any columns hidden by default within the columns you selected to freeze. Therefore the actual number of columns displayed as frozen will not match the number of columns you selected to freeze.

You can 'unfreeze' previously locked columns by selecting None (0) when specifying the number of columns to freeze.
Group Dates by Date Groups dates in the listview by the actual date. The data in the listview must be refreshed before the change is effected.
Date Format The format in which you want to display dates in the listview.
Group By This Field Resequence the data in the listview according to the entries in a specific column (except for listviews that display a limited number of rows at a time).

The rows in the selected column are sorted and displayed together in a tree view structure according to the commonality of the data in each row. The column heading on which the data is grouped is displayed as a field above the listview heading and an arrow against the field enables you to sort the groups in ascending or descending order.

You can create a sub grouping by selecting the Group By This Field option against another column.

To restore the listview to its original settings, you can either select the Reset View option, or drag the column headings you are grouping by back into the listview headings.
Group by Box This performs the same function as the Group By This Field option, except that this option displays an area above the listview heading into which you can drag the column names by which you want to group the listview data (i.e. you do not have to select the Group by Box function from a specific column heading in the listview using your mouse pointer).
Remove this Column Deletes the currently selected column from the listview.

You can restore the column to the listview by selecting the Field Chooser option and dragging the column back onto the listview.
Field Chooser Displays a list of columns that are available to be dragged onto the listview. You can use this option to restore previously removed columns to the listview.

When you add a custom form column to the listview, you can click in a cell of that column and use the Show all custom form fields option to display all custom form fields in that column.

This option is not available when your User Interface is designed by operator role (Customization Management). This is by design. When the user interface is controlled at role level, operators should not be allowed access to any additional columns not in the role. Note that the operator is not prevented from removing columns from the listview, but these can be restored using the Reset View option.
Automatic Column Sizing Displays all columns within the available display space for the listview.

For listviews with numerous columns, this can result in the width of some columns being less than the width of the data within a column.

The horizontal slider bar at the bottom of the listview is removed as the entire listview is displayed within the available space.

For listviews with few columns, the columns are expanded to fit the available space.

If you select this option together with the Best Fit option, then columns are resized only within the available space, as the Automatic Column Sizing option takes precedence over the Best Fit option.

Best Fit Resizes each column to the width of the column heading. It does not resize the column to the width of the data.

If you selected the Automatic Column Sizing option, then columns are only expanded to the display size of the listview, as the Automatic Column Sizing option takes precedence over the Best Fit option.

Alignment Aligns the data within the currently selected column either to the left, to the right or to the center.

This option can only be selected using your mouse pointer on the required column heading.
Auto Preview Automatically displays additional text attached to the row. This only applies in listviews where Preview Text can be added.

For example: When you add notes to an activity using the Contact Activity Posting program, then you can select this option to display these notes against the activity in the Activities listview of the Contact Query program.
Smart Link Enables Smart Links in the listview.

A Smart Link is a customizable mini-menu that allows you to launch predefined context-sensitive functionality, SYSPRO programs or executables (.exe) that you have added. Smart Links become available when you move your mouse pointer over a column that has been configured to be Smart Link-aware. This is indicated by an icon containing an 'i' with a circle around it.
Multi-line Layout Enables you to display information in a listview column over multiple lines. The information is wrapped around onto additional lines within the width defined for the column. This means that you can view all the information in the column without having to expand the size of the column.

You typically use this option on a column which contains a lot of information (e.g. Stock code description, Stock Code long description or an Address column).

[Note]

This option only applies to some listviews and listview columns (i.e. it cannot be applied to all columns in all listviews).

When you select this option, the horizontal slider bar at the bottom of the listview may be removed.
Multi-line Headings Displays column headings on multiple lines when you reduce the column width. The heading is wrapped around onto additional lines within the width defined for the column.

If you do not select this option, then the heading is truncated according to the size of the column.

When you select this option, the Multi-line layout option is automatically selected and cannot be deselected.

Filter Rows Reduces the number of rows displayed to include only those containing specified text.

This provides a useful search type facility to locate specific rows in the listview.

When you select this option, you are prompted for the text on which you want to filter the rows. As you enter the text, only those rows containing the text you entered are displayed in the listview.

[Note]

Filtering is only performed on the rows currently displayed in the listview and not on all the rows stored in the data files/tables.
Filter by Column

Inserts a blank line between the column header and the listview cells.

When you select this area above a column, the values for that column are displayed in a dropdown list. Once a value is selected from the dropdown list, only rows that match that value are displayed in the listview.
Autosum

Autosum options are applied to the column selected.

Automatic summing and averaging can be applied to numeric columns only.

[Note]

Hidden rows are excluded from the totals.
Column sum Adds the value of all entries in the column and display the total in the column footer.
Column Average Calculates the average value of the values in the column. This adds all values in the column and divides the result by the number of rows in the column.
Row Count Adds the number of rows in the column and displays the total in the column footer.
Group Totals Displays sub-totals at the change of each group.

Totals are shown on change of the grouped field in bold.

The columns that are subtotalled are the ones selected in the Auto Sum Columns option.

The word 'Subtotal:' is displayed in the first column of the subtotal record.

You only can produce subtotals if a single column is grouped.

If you use the Filter Rows feature (CTRL+F), then you can type in 'sub' and to display only the sub total rows.
Remove All Removes all Autosum footer totals currently displayed.
Conditional Formatting This can be applied to numeric or date columns in a listview.
Top 10 Highlights the highest 10 values or the latest dates in the selected column.
Bottom 10 Highlights the lowest 10 values or oldest dates in the selected column.
Advanced Performs sophisticated cell and row formatting to highlight exceptions using the Conditional Formatting program.

Up to 10 rules for each listview can be applied.

Advanced conditional formating cannot be applied to any of the SRS Documents > SRS Document Archive Viewers listviews.
Remove All Removes all conditional formatting previously applied to the listview.
Adjust Rows to Display Indicate the number of rows to display in the current listview at any one time.

The vertical scroll bar on the right hand side of the listview can be used to scroll up or down the rows.

If there are multiple tabs above a listview, then each of these is a separate listview. This means you can define the number of rows to return against each listview tab individually.

The Default number of rows to return option controls the default number of rows to apply on the initial loading of a listview.

[Note]

Press Ctrl and F9 on your keyboard for a shortcut to this function.
Find and Replace This option is only enabled for data grids. It enables you to locate text you entered and to replace it with different text.
Reset View Resets the listview to its standard SYSPRO default settings. The customizations you applied to the listview are removed/reversed.

If your operator code belongs to a role, then the listview is reset to the defaults defined against the role layout design.
Clear Sort Items This option is only enabled after you sort the listview on a specific column. The listview remains sorted on that column until you select this option.

This removes the sort indicator (up or down triangular arrow). The data is sorted on the default column the next time you load the listview. The data remains displayed in the same order for the current run of the program. Use the Reset View option to reset the data to be displayed in the default order without exiting the listview.
Expand All Rows When you use the Group By This Field or Group by Box options to group the data within the listview, the listview rows are arranged in a tree view structure.

You use this option to display all rows in the 'tree view' structure.
Collapse All Rows

Displays only the column by which you selected to group the items (i.e. the 'root' of the tree for each group).
Rows Indicates the total number or rows currently being displayed in the listview.