Completed
Last Updated: 20 Jan 2023 12:34 by ADMIN
Release R1 2023
Ryan
Created on: 18 Jan 2022 17:36
Type: Feature Request
4
Feature Request: Excel like SWITCH and IFS statements

I have encountered scenarios where I want to return different results based on fields value or some expression. While I can use nested ternary operations this is not ideal as it can be difficult to read and maintain, particular for newer report designers. It would be helpful to have SWITCH and IFS statements modeled after those provided by Excel.

SWITCH would be helpful for cases where I want to check against a few different literal values and return different results.

IFS would be helpful for cases where I want to evaluate different expressions and return different results.

Modeling these after those in Excel would be sufficient, though, for more advanced cases being able to write C# code inline with the report would be helpful (will submit as a separate request).

3 comments
ADMIN
Ivan Hristov
Posted on: 20 Jan 2023 12:23

Hello Ryan,

Just wanted to inform you that in our latest release R1 2023 we introduced new conditional functions: we added Switch and IFS functions that should replace the old IIF function, providing more flexibility and facilitating the writing of conditional expressions.

We will appreciate it if you give it a try and share your thoughts.

All best,

Ivan Hristov

Telerik Reporting Team

ADMIN
Neli
Posted on: 19 Jan 2022 10:10

Hello Ryan,

Thank you for logging this feature request. I voted for it on your behalf. When there is an update on the status, you will get a notification.

Regards,
Neli
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Ryan
Posted on: 18 Jan 2022 17:36
I originally posted this request in the Forums, here: https://www.telerik.com/forums/feature-request-if-elseif-else-and-or-switch-statement-support-in-expressions