I am a network guy and not at all a programmer, but as I work for a small unit in a big company I have been given duties for a specific job and can not complete.
I am trying to write code for a crystal report to do to theings. One is to take data out of database record that has specific strings and if returned the strings then post an alpha value in retur. This is what I wrote

iF {Part_Master.COMCDE_01}.STRING = EC9 or C09 or CO0 OR ECC OR COC OR ECT OR COT OR ECCR OR CRF OR ECWP OR WPF THEN
"RED"
ELSE
RCBW OR RCSO OR RABW OR RASO OR STE THEN
"CLR"
ELSE
MEX OR WPS OR WPW OR SGW OR WP3 OR WPM OR WPE OR CR3 OR CRM OR CRE OR ABE OR EKE OR CAE OR LAE THEN
"ELB"
ELSE
TE9 OR TE1 OR TECR OR TEWP THEN
"TEES"
ELSE
"SP"
END IF

Does not like it

The next thing I have to do is display a specific section of a String that is a value in the report from a foield in a database

The value is similar to the 4125321937. I need to display the forth and fifth characters of the string but have no idea.

Can anyone help me?

Member Avatar for iamthwee
  1. Are you using crystal or basic syntax with your reports?

basic syntax

basic syntax

Member Avatar for iamthwee

Right, I mainly use crystal syntax but I'll try to help anyway.

iF {Part_Master.COMCDE_01}.STRING = EC9 or C09 or CO0 OR ECC OR COC OR ECT OR COT OR ECCR OR CRF OR ECWP OR WPF THEN

Try testing the below and tell me if it works.

iF {Part_Master.COMCDE_01} ="EC9" or "C09" THEN
"YES"
ELSE
"NO"
END IF

The first line of code is no error, but it is highlighting the "Yes" with an error that a statement is expected here

Member Avatar for iamthwee

What happened?

Member Avatar for iamthwee

Are you using only the code I posted and nothing else. Did you copy and paste it into the formula? Have you put the quote marks around the EC9 etc.

I deleted my complete code and did a copy and paste of yours including the quotes.

Member Avatar for iamthwee

What happens if you do

iF {Part_Master.COMCDE_01} = "EC9" or "C09" THEN
1
ELSE
0
END IF

Member Avatar for iamthwee

What version of crystal reports are you using?

My security company wants me to leave. I am out of the office tomorrow...thank you for your help and I will look again Tuesday to see if available

Oh it is version 10

Member Avatar for iamthwee

Ok, I'll look at this tomorrow, at the moment I'm working blind, so there could be a syntax error (possibly the newline), as I said I normally use Crystal syntax.

Member Avatar for iamthwee

I believe you need to something like:-

If {Part_Master.COMCDE_01} = "002" Then
Formula = "ok"
ElseIf {Part_Master.COMCDE_01} = "001" Then
Formula = "no"
Else
 Formula = "maybe"
End If
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.