Show/Hide fields dialog

You can use the Show/hide fields dialog to choose the fields that you want to appear in your drillthrough report.

• Shown fields appear on the left and Hidden fields on the right. Select fields and use the arrow buttons to move them from one area to the other.
  • "Shift-click" selects multiple adjacent fields at once.
  • "CTRL-click" selects multiple non-adjacent fields at once.

• Once you have moved the fields you want into the Shown fields area, you can use the "Move to top," "Move field up," "Move field down," and "Move to bottom" arrow buttons to change their order.
• Click OK to apply your changes and return to the drillthrough.

  Note: At least one field must be shown in a drillthrough.

  Note: You can also hide fields by clicking the X buttons in the column headers.

  Note: Not all of the fields in the source records for a table can reasonably be used or combined in a drillthrough report. Therefore you should think twice before adding all fields to a drillthrough or creating a filter using all possible fields. For example, it would not make sense to join the Fact Table with the Missing Values table or the Footnotes table. Selecting invalid fields or combinations of fields will produce the following error message: "Build query: Invalid table list or attempt to display fields from unrelated tables."