Muj Muj - 1 year ago 91 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.



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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download