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=2025-12-01T14%3A02%3A50Z&se=2025-12-01T14%3A13%3A50Z&sr=c&sp=r&sig=tjq5B%2BEiLsX6vilhLakiASq7LWs4VszCNlYLCfAQ%2F3c%3D)
Now the properties are set and saved.
.png?sv=2022-11-02&spr=https&st=2025-12-01T14%3A02%3A50Z&se=2025-12-01T14%3A13%3A50Z&sr=c&sp=r&sig=tjq5B%2BEiLsX6vilhLakiASq7LWs4VszCNlYLCfAQ%2F3c%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=2025-12-01T14%3A02%3A50Z&se=2025-12-01T14%3A13%3A50Z&sr=c&sp=r&sig=tjq5B%2BEiLsX6vilhLakiASq7LWs4VszCNlYLCfAQ%2F3c%3D)