Episode 4: Excel Function: RW.Tools.Sort aka RWSort
Quote from Karen Hewitt on July 15, 2026, 6:59 amEpisode 4 is here and this one's all about sorting your data consistently and reliably upon data refresh.
RW.Tools.Suppress controls what shows up. RW.Tools.PageBreak controls where it lands. RW.Tools.Resize makes sure it all fits.
RW.Tools.Sort sorts your report data at generation time, with support for up to three sort keys and new in v5.0.0.91 is an optional TOP or BOTTOM limit so you can return only the rows you need without a separate suppress step.
Whether you're building a ranked top 10 report, sorting a headcount list by department and name, or just making sure your data comes out in a consistent order regardless of how the source returned it: RW.Tools.Sort handles it all in a single formula placed in your template.
Quick heads up on naming: RWSort changes to RW.Tools.Sort in the official release (v5.0.0.91), but RWSort will still function as expected no need to convert your existing templates to the new name.
The TOP/BOTTOM limit arguments are new in v5.0.0.91 and are not available in earlier versions. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached: RW.Tools.Sort_Examples for v5.0.0.91 or later and RWSort_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 run the test. No other modification to the job is needed.
Let us know what you think and if you have any questions!
Episode 4 is here and this one's all about sorting your data consistently and reliably upon data refresh.
RW.Tools.Suppress controls what shows up. RW.Tools.PageBreak controls where it lands. RW.Tools.Resize makes sure it all fits.
RW.Tools.Sort sorts your report data at generation time, with support for up to three sort keys and new in v5.0.0.91 is an optional TOP or BOTTOM limit so you can return only the rows you need without a separate suppress step.
Whether you're building a ranked top 10 report, sorting a headcount list by department and name, or just making sure your data comes out in a consistent order regardless of how the source returned it: RW.Tools.Sort handles it all in a single formula placed in your template.
Quick heads up on naming: RWSort changes to RW.Tools.Sort in the official release (v5.0.0.91), but RWSort will still function as expected no need to convert your existing templates to the new name.
The TOP/BOTTOM limit arguments are new in v5.0.0.91 and are not available in earlier versions. We've attached two Excel files for a more detailed walkthrough of the formula in action.
Two files attached: RW.Tools.Sort_Examples for v5.0.0.91 or later and RWSort_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 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.