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-22T04%3A03%3A41Z&se=2025-12-22T04%3A14%3A41Z&sr=c&sp=r&sig=esdyUXkj6e%2B4b8rrvRR45TPGcKRTy0pG4LJkY8pDc4o%3D)
Now the properties are set and saved.
.png?sv=2022-11-02&spr=https&st=2025-12-22T04%3A03%3A41Z&se=2025-12-22T04%3A14%3A41Z&sr=c&sp=r&sig=esdyUXkj6e%2B4b8rrvRR45TPGcKRTy0pG4LJkY8pDc4o%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-22T04%3A03%3A41Z&se=2025-12-22T04%3A14%3A41Z&sr=c&sp=r&sig=esdyUXkj6e%2B4b8rrvRR45TPGcKRTy0pG4LJkY8pDc4o%3D)