Episode 1: Excel Function: RW.Tools.Suppress aka RWSuppress
Quote from arachmiel@reportworq.com on June 2, 2026, 8:21 amWe're launching a new video series covering the things you work with every day from formulas, jobs, bursting, distribution, and more. Short, focused, and straight to the point.
We're spending the first few weeks going deep on RW Formulas. One formula, one video, in under 5 minutes. It's the fastest way to build a solid foundation before we move into jobs, bursting, and distribution. Think of it as the reference library you'll come back to again and again.
Below is Episode 1: RW.Tools.Suppress aka RWSuppress. This is one of the most-used worksheet formulas in Reportworq and a great place to start.
Quick heads up on naming: RWSuppress changes to RW.Tools.Suppress in the next official release (v5.0.0.91), but RWSuppress will still function as expected - no need to convert your existing templates to the new name. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached:
- RW.Tools.Suppress_Examples - for v5.0.0.91 or later
- RWSuppress_Examples - for current versions
You can create a simple job in Reportworq and use the file as your report source to see the formula work in a real job run. Just select Excel in the distribution screen and then run the test, no other modification to the job is needed.
Let us know what you think and if you have any questions!
We're launching a new video series covering the things you work with every day from formulas, jobs, bursting, distribution, and more. Short, focused, and straight to the point.
We're spending the first few weeks going deep on RW Formulas. One formula, one video, in under 5 minutes. It's the fastest way to build a solid foundation before we move into jobs, bursting, and distribution. Think of it as the reference library you'll come back to again and again.
Below is Episode 1: RW.Tools.Suppress aka RWSuppress. This is one of the most-used worksheet formulas in Reportworq and a great place to start.
Quick heads up on naming: RWSuppress changes to RW.Tools.Suppress in the next official release (v5.0.0.91), but RWSuppress will still function as expected - no need to convert your existing templates to the new name. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached:
- RW.Tools.Suppress_Examples - for v5.0.0.91 or later
- RWSuppress_Examples - for current versions
You can create a simple job in Reportworq and use the file as your report source to see the formula work in a real job run. Just select Excel in the distribution screen and then run the test, no other modification to the job is needed.
Let us know what you think and if you have any questions!
Uploaded files:- You need to login to have access to uploads.