•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 402,059 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,398 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 786 | Replies: 14
 |
•
•
Join Date: Jan 2008
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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?
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?
•
•
Join Date: Aug 2005
Posts: 4,711
Reputation:
Rep Power: 17
Solved Threads: 309
- Are you using crystal or basic syntax with your reports?
Last edited by iamthwee : Jan 20th, 2008 at 2:44 pm.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Jan 2008
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
basic syntax
•
•
Join Date: Jan 2008
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
basic syntax
•
•
Join Date: Aug 2005
Posts: 4,711
Reputation:
Rep Power: 17
Solved Threads: 309
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
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
Last edited by iamthwee : Jan 20th, 2008 at 2:56 pm.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Jan 2008
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
The first line of code is no error, but it is highlighting the "Yes" with an error that a statement is expected here
•
•
Join Date: Aug 2005
Posts: 4,711
Reputation:
Rep Power: 17
Solved Threads: 309
What happened?
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Aug 2005
Posts: 4,711
Reputation:
Rep Power: 17
Solved Threads: 309
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.
Last edited by iamthwee : Jan 20th, 2008 at 3:14 pm.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Jan 2008
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
I deleted my complete code and did a copy and paste of yours including the quotes.
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- MySQL syntax error check for the right syntax to use near 'A (A) )' at line 1 (PHP)
- Error "Syntax" (Windows 9x / Me)
- DECLARATION SYNTAX ERROR (for bc 31 user) (C++)
- MySQL newbie need help with create table definitons syntax (MySQL)
- Parse error, syntax error, Forbids declaration (C++)
- Syntax for deleting specified file ( in C++) (C++)
- C++ Syntax (C++)
Other Threads in the Database Design Forum
- Previous Thread: Database 101 question
- Next Thread: Need opinions on a database design
