# Crystal Calculated field Syntax help

Jim,

Don't know this off the top of my head, but when you get into formula
builder, it's got drop downs for those functions and excellent help. It
should pretty much walk you through the syntax.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Moore, Jim (Anniston)
Sent: Thursday, January 13, 2011 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Calculated field Syntax help

I'm converting a Vantage 6.1 Report Builder report to Crystal XI Release
2 for Epicor 9.04.

I need help with the syntax for a calculated field.

In Vantage 6.1 report builder, the syntax for the calculated field is:

iif(numeric(substring(JobHead.JobNum, INDEX(JobHead.JobNum,'-', 6) + 1))
= ?, yes, no)

What should the syntax be for Crystal Reports?

Thanks,

Jim Moore
----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]
I'm converting a Vantage 6.1 Report Builder report to Crystal XI Release
2 for Epicor 9.04.

I need help with the syntax for a calculated field.

In Vantage 6.1 report builder, the syntax for the calculated field is:

iif(numeric(substring(JobHead.JobNum, INDEX(JobHead.JobNum,'-', 6) + 1))
= ?, yes, no)

What should the syntax be for Crystal Reports?

Thanks,

Jim Moore
------------------------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
------------------------------------------------------------------------
-----

[Non-text portions of this message have been removed]
I think this is what you want:

if isnumeric(mid({JobHead.JobNum},instr({JobHead.JobNum},"-",6)+1)) =
false then true else false

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Moore, Jim (Anniston)
Sent: Thursday, January 13, 2011 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Calculated field Syntax help

I'm converting a Vantage 6.1 Report Builder report to Crystal XI Release
2 for Epicor 9.04.

I need help with the syntax for a calculated field.

In Vantage 6.1 report builder, the syntax for the calculated field is:

iif(numeric(substring(JobHead.JobNum, INDEX(JobHead.JobNum,'-', 6) + 1))
= ?, yes, no)

What should the syntax be for Crystal Reports?

Thanks,

Jim Moore
----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]