When designing a report in SpotlightXL, you can set report properties to suppress rows or columns that have only zeros, blanks, or either zeros or blanks.
Here is a look at a report without suppression.
.png?sv=2022-11-02&spr=https&st=2026-01-11T22%3A39%3A37Z&se=2026-01-11T22%3A50%3A37Z&sr=c&sp=r&sig=kTnhisI%2FM1UqI6d4jg7HZE4ZH%2BzfpdQMWsY68lpw5WQ%3D)
Now the properties are set and saved.
.png?sv=2022-11-02&spr=https&st=2026-01-11T22%3A39%3A37Z&se=2026-01-11T22%3A50%3A37Z&sr=c&sp=r&sig=kTnhisI%2FM1UqI6d4jg7HZE4ZH%2BzfpdQMWsY68lpw5WQ%3D)
When viewing the report in Spotlight Web Reporting, these properties are honored; blank rows are omitted.
.png?sv=2022-11-02&spr=https&st=2026-01-11T22%3A39%3A37Z&se=2026-01-11T22%3A50%3A37Z&sr=c&sp=r&sig=kTnhisI%2FM1UqI6d4jg7HZE4ZH%2BzfpdQMWsY68lpw5WQ%3D)