Back

Report Settings: Available/Selected Columns

Contents

How Available/Selected Columns Works

Columns Available

In Dynamic Reports

In PDF Reports

Edit Column Name

Set Minimum Column Width

Determine Column Header Behavior

Reports With This Setting

Related Settings

 

How Available/Selected Columns Works

Applies to:
✔ Dynamic ✔ PDF

✔ Client Portal

 

This setting allows you to choose the columns you want to appear on the report.

Top of Page

Columns Available

The exact columns available will vary by report. Some reports may allow you to use this same feature to add or remove rows.

Note

The available columns include custom fields for accounts, groups, Households, and securities. For more information about custom fields, see Custom Fields for Accounts, Reporting Groups, Households, and Securities.

Top of Page

In Dynamic Reports

On dynamic reports, you can edit the name of each column to adhere to your firm's naming conventions.

To edit a column name in a dynamic report:

  1. Add the desired column to the Selected columns list.

  2. Click the column name.

  3. Under Formatted name, clear the Use default check box.

  4. Type in the custom name for the column.

  5. Click Save to save all edits to the report settings.

Notes

Top of Page

In PDF Reports

On PDF reports, when you add columns, the following settings are available:

Edit Column Name

Set Minimum Column Width

Determine Column Header Behavior

Top of Page

Edit Column Name

To edit a column name in a PDF report:

  1. Add the desired column to the Selected columns list.

  2. Double-click the column name.

  3. In Edit Column Details, type the desired name in the Display as field.

  4. Click Change.

For more information about customizing column names, see Customize the Name of Column Headings for PDF Reports.

Top of Page

Set Minimum Column Width

To ensure that your column names fit, you can set a minimum column width:

  1. Add the desired column to the Selected columns list.

  2. Double-click the column name.

  3. In Edit Column Details, select the Use a minimum column width of ___ characters check box.

  4. Enter the number of characters you want the column to fit.

  5. Click Change.

Top of Page

Determine Column Header Behavior

If a column name is too long to fit in the width available, you can set what happens to the header. You have the following options:

Setting Report Output
Wrap

The row height will be increased so that you can see all the text. Typically the wrapping will occur where there is a space.

Truncate

The text will be cut off at the minimum width you set.

Ellipsis

You'll see an ellipsis after your truncated text to indicate there's more text than what is shown.

 

To set header text behavior:

  1. Add the desired column to the Selected columns list.

  2. Double-click the column name.

  3. In Edit Column Details, under Header text, choose the desired behavior.

  4. Click Change.

    Note

    In the Selected columns list, columns with customized widths are green. Columns with default widths are black.

For more information about custom column widths, see Set Column Widths for PDF Reports.

Top of Page

Reports With This Setting

Performance Reports

Holdings Reports

Transaction Reports

 

Top of Page

Related Settings

For more information about column widths in PDF reports, see Set Column Widths for PDF Reports.

For more information about customizing column names, see Customize the Name of Column Headings for PDF Reports.

Top of Page