# Define sheets

Command Description

In the Advanced Report – Define Sheets dialog, you can create customized reports. You can set sheet titles and subtitles, sort data, apply conditional formatting, and adjust the column layout using the right-click menu.

How to define sheets

  1. After selecting the attributes to display in the Manage Columns dialog, proceed to define sheets in the Advanced Report – Define Sheets dialog.

  2. In the upper left, you will find the tabs. The default tab is named Sheet1, which you can rename by right-clicking.

  1. You can create a new sheet by clicking the “+” tab. The “Sheet Name” dialog opens, where you can define the name of the new sheet.

  1. You can remove the sheet with right-click.

  2. In the upper part of the dialog, define the dataset name, sheet title, and sheet subtitle.

  3. All attributes marked as visible in Manage Columns are listed in the dialog. You can sort data in ascending or descending order, apply conditional formatting, rearrange columns, hide or pin them, and adjust their size using the right-click menu.

  • Sort Ascending: Sorts the data in the selected column from smallest to largest, or alphabetically from A to Z.
  • Sort Descending: Sorts the data in the selected column from largest to smallest, or alphabetically from Z to A.
  • Clear Sorting: Removes any sorting applied to the selected column.
  • Conditional Formatting: Allows you to apply formatting rules.
  • Group by this column: Groups the data by the values in the selected column.
  • Column Chooser: Opens a list of available columns so you can add or remove them from the report.
  • Hide Column: Hides the selected column from the report view.
  • Expression: Lets you define a custom expression to display calculated values in the column.
  • Pinned state: Pins the column to the left or right side of the report, so it remains visible while scrolling.
  • Best Fit: Automatically adjusts the width of the selected column to fit its content.

← Group data →