It is possible to achieve similar behavior for the table element in the viewer. You can filter data during runtime without having to modify your SQL queries too much by taking advantage of "client-side" filtering.
To the that you need to create parameters that will be your filtering conditions and add filters to the table you can check Adding Filtering to Table and Crosstab Items - Telerik reporting documentation for more information on how to do that.
I am attaching a sample report that illustrates this. Could you give it a try and let me know if the approach I suggested will work for you?