Page 1 of 1

Check if data column contains specified value

Posted: Fri Sep 06, 2024 1:41 pm
by jaqb
Hi,
Is it possible to check if data column contains specifed value? I need to add condition for displaying text field, based on whether the data that I've received from the server contains object with specifed string property.

Re: Check if data column contains specified value

Posted: Fri Sep 06, 2024 2:21 pm
by Lech Kulikowski
Hello,

You can use the following expression:
{datasourceName.ColumnName.Contains("value)}

Thank you.

Re: Check if data column contains specified value

Posted: Mon Sep 09, 2024 7:27 am
by jaqb
Unfortunately, it does not work as I excepted. I've attached sample files where I have report with 4 gray shapes and I want to make specifed shape green if it exists in the data column. All 4 shapes exist in the data column but only first (circle) is taken into account.

Re: Check if data column contains specified value

Posted: Wed Sep 11, 2024 10:01 pm
by Lech Kulikowski
Hello,

The result is correct. If you don't use DataBand, the source.column expression returns only the first record from the source.

Thank you.