Using SpotlightXL-Reports Additional Features

There are additional functionalities available in the Reports section. See below for examples:

Function Support

The following functions are supported in SpotlightXL:

• Arithmetic Operators: + - / *
• Logical Operators used with IF function: = <> < <= > <=
• Functions: IF/THEN, AND, OR, ROUND, FLOOR, CEILING, LN, ISBLANK, ABS, SQRT, POWER, MOD

Negative Amounts in Reports

Dynamic Planning supports native Microsoft Excel negative number selections. In Report Design mode, select the report, right-click, and select Format Cells as shown below.

When the Format Cells dialog page is displayed, select the Number tab and then select the Number or Currency Category as shown below.

Select a negative number format and click OK. Save the report in SpotlightXL.

Repeat Headers Across Multiple Pages

Repeating headers across printed pages allows you to see the column and row headers when a report exceeds the width and height of the page. You can select to repeat the top row(s) and the leftmost column(s) of a report.

How to Repeat Headers Across Multiple Pages?

1. In SpotlightXL, go to the Report > Design, and select a desired report.
2. Select Page Layout, Print Titles, and Sheet.
3. Select Rows to repeat at the top and Columns to repeat at the left as shown below.
4. Select SpotlightXL and save to retain the changes in SpotlightXL.

You can repeat rows, columns, or both. Reviewer users cannot change the Repeat setting. Page break settings are saved with the report definition. That means each user that runs the report will have these settings applied when printing.

How to Use Multi-tab Reporting?

Multi-tab reporting allows you to open multiple tabs with different reports.

1. To open multiple tabs with different reports in SpotlightXL, select Report > Run.
2. Select the report from the Report list box.
3. Add another tab by clicking the + icon to the right of the tabs.
4. Select Report >Run, then select another report from the Report list box. The tab name will be updated with the report name.

To display the same report in multiple tabs, perform the same steps above, but select the same report from the Report list box.

You can save your workbook with multiple tabs displaying and use this as a starting point for future analysis and reporting with updated data. Open the workbook and update all open reports by selecting the Refresh All Open Reports option shown below. In addition, you can update each report individually by selecting the Refresh option on each tab, if desired.