Muj Muj - 16 days ago 4
Vb.net Question

Crystal Reports IN-Statement

I don't know if this question already exist in here. My problem is that i don't know how to search this or what should i type to show corresponding answer to this problem. so bare with me.

My problem is, how can i use this kind of condition in crystal report.

Inside

SUPPRESS
condition

If {REP_AccountingCashFlow_Get;1.ReferenceIdentifier} IN (1, 5, 9, 10) THEN
TRUE Suppress TRUE


My error when i check my condition is
The ) is missing


Anyone know how to solve this? or proper way to use this kind of condition in
Crystal Reports
?

Answer

According here, Crystal Reports uses brackets[] instead of parenthesis().

So it would likely be ...IN [1, 5, 9, 10] instead.

And your statement should be:

{REP_AccountingCashFlow_Get;1.ReferenceIdentifier} IN [1, 5, 9, 10]

You don't need to put an if condition anymore since adding a formula for Suppress is already considered an if statement that when matches your criteria will suppress the object in your Crystal Report.