Creating reports and dashboards | Stimulsoft community forum

I'm evaluating your software for use with our flex-based software. I'm trying to create a report that lists individuals and their phone numbers. Some individuals do not have phone numbers, so I want to check for 'null' values and output an empty string if that is the case.

If I do nothing, using {registrant_data.phone_number}, then the report outputs 'null' in the phone column for those individuals without phone numbers and the correct phone number for those who do have phone numbers.

If I use the expression or then I get nothing in the output, even for those registrants with phone numbers.

I also have another situation where I need to check registrants against a guardian name. If they are the same, meaning they have no guardian, then it should display nothing. If they are different, meaning they have a guardian, it should display the guardian name. However, the following expression does not work:
My question is, what do I need to do to get the IIF function to compare and output the correct values?

Also, I am sending the report data via XML

Hello,

Please try to use the following expressions:
Thank you.

Thank you. That fixed it.

Ok!

Have a great day!

Thank you.

Hello,

I am having a similar issue, however, I am attempting to evaluate a boolean instead of a string.

Using the previous example, let's say I have a boolean labeled registrant_data.has_phone_number. First, I need to check if the expression is null. If it's not null, I need to check the value of the has_phone_number boolean. If it is true, I want to display the text "Has Phone Number" in a grid. If the value is false, I want to display "Does Not Have Phone Number".

The expression:
Does not work because the IFF expects a string instead of a boolean. Is there a way around this?

Thanks,
Paul

Hello, Paul.

PRabbat wrote:I am having a similar issue, however, I am attempting to evaluate a boolean instead of a string.

Using the previous example, let's say I have a boolean labeled registrant_data.has_phone_number. First, I need to check if the expression is null. If it's not null, I need to check the value of the has_phone_number boolean. If it is true, I want to display the text "Has Phone Number" in a grid. If the value is false, I want to display "Does Not Have Phone Number".

The expression:

Code: Select all

{(registrant_data.has_phone_number == null) ? "" : registrant_data.has_phone_number}
{IIF((registrant_data.has_phone_number == null),"",registrant_data.has_phone_number)}
{IIF((registrant_data.has_phone_number),"Has Phone Number", "Does Not Have Phone Number")}

Does not work because the IFF expects a string instead of a boolean. Is there a way around this?

Which expression of three ones do you use?

Thank you.

I am using the expression:
As stated before, has_phone_number is a boolean.

Hello,

We check this expression and it is work correctly.
Can you please send us your report with test data for analysis.

Thank you.

Hiii
can any one help me out how to use multiple if else condition using IIF with example

im using this expression {(registrant_data.has_phone_number == null) ? "" : registrant_data.has_phone_number}

and i want to execute if elseif else

im getting syntax error or the output is blank.

thanks in advance

Hello.

Please, try to remove Braces {} from your expression.

Thank you.