I have a table component with a field set as checkbox and want to set the checked state of this checkbox based on an if condition.
If I would have written this in SQL Server I'd do it in this way:
IF ds2.Aardrailsysteem LIKE '%Hoofd aardrail%'
BEGIN
RETURN TRUE
END
ELSE
BEGIN
RETURN FALSE
END
Would it be possible to do it in such a way?
{IIF ds2.Aardrailsysteem LIKE '%Hoofd aardrail%', true, false}
I'm curious how I should handle LIKE or contains for the checkbox in Stimulsoft
Set checked state of checkbox based on contains/like
Set checked state of checkbox based on contains/like
- Attachments
-
- Properties of checkbox
- TableImage2.png (11.05 KiB) Viewed 2832 times
-
- Table component
- TableImage1.png (7.22 KiB) Viewed 2832 times
Re: Set checked state of checkbox based on contains/like
Hello,
You can use the following expression:
Thank you.
You can use the following expression:
Code: Select all
{IIF(Categories.CategoryName.Contains("Prod"), true, false)}
- Attachments
-
- Capture.PNG (75.34 KiB) Viewed 2828 times