The Settings tab in the Cosmos Report Editor provides the user with several settings to enable more control over the report authoring process.
This article covers each of the available settings and how to use them.
When creating or modifying a report, there a several settings that can be adjusted to tailor the report authoring process to each Report Editor's specific needs.
The user will access the settings by clicking on the Settings tab of the Cosmos Report Editor. They will then see the settings outlined below.
Filter Content to Current Sheet: If this box is checked, content displayed in the Report Editor tab will only be shown for the sheet that the user is currently viewing. If the box is unchecked the user will see content for all sheets.
Filter Field to Selected Cell(s): If this box is checked, content displayed in the Report Editor tab will only be shown for the cell(s) that the user has selected in the report. This can be very useful to only see content relevant to the current selection. If the box is unchecked the user will see content for all fields.
Filter Range Lists to Selected Cell(s): If this box is checked, Range Lists displayed in the Report Editor tab will only be shown only when they are related to the cell(s) that the user currently has selected. If the box is unchecked the user will see all Range Lists in the Range List section of the Report Editor.
Show Diagnostic Details: Checking this box will show technical details of the Cosmos functions in the report, such as Function IDs represented as GUIDs. Users will typically only use this when working with the Cosmos Support Team to troubleshoot a report issue.
Show Developer Tools: This will enable a Developer Tools section in the Report Editor tab for certain function types. One example is an additional button for Range Lists named "Toggle Border", that will place a permanent border around Range Lists to give the user a better visual indicator of how the Range Lists are arranged. It is important to note that since this leverages standard Excel border functionality, if this is toggled on and then off it will remove any existing border that existed around the Range List prior to it being toggled on.
Range Display Style: This dropdown has two options:
- Excel Address: This will show the standard Excel address (e.g.: A1:C3) in the Report Editor tab for things such as the Address Range for Range Lists.
- Coordinates: This will show a coordinate representation in the Report Editor tab for things such as the Address Range for Range Lists. Using this setting is uncommon.