Group Name Conversion

[TEM3]

Using Crystal Reports 8.5 and Oracle 9i.....

I have a report that groups (and does a sum total) tests and then the results of those test. Of of the groups ("Blood Alcohol %WT/VL") needs to have the results further summarized. The field ({ARRESULT.Result}) is a text field that contains data such as:

0.058, 0.083%, 0.117, 0.234, Not Analyzed, Not Detected, Positive, etc.

What I need to do is to test for a number (0.058 or 0.083%) and group the results into <= 0.100% or >0.100%. If the field is not a number (does not begin with "0.") it would be reported as saved ("Not Analyzed", "Not Detected", etc.).

Can someone get me started by an example of testing {ARRESULT.Result} for "0." and, if true, converting the data to a number?

 

[TEM3]

Here is my attempt - I get a "string is non-numeric" error:

if {ARTEST.Description} = "Blood Alcohol %WT/VL" and {ARRESULT.Result} startswith "0." then
(
if tonumber({ARRESULT.Result}) > 0.10 then "Number of blood specimens positive for > 0.1%" else
if tonumber({ARRESULT.Result}) <= 0.10 then "Number of blood specimens below 0.1%" else
if tonumber({ARRESULT.Result}) = 0.10 then "Number of blood specimens equal to 0.1%"
)
else
(
{ARTEST.Description}
);

 

[GJParker]

using your example you would need something like

Local stringvar Test := Left({ARRESULT.Result},5);

If {ARTEST.Description} = "Blood Alcohol %WT/VL" AND IsNumeric(Test) Then
   If Val(Test) > 0.10 Then 
       "Number of blood specimens positive for > 0.1%"
   Else If Val(Test) <= 0.10 Then 
       "Number of blood specimens below 0.1%" 
   Else If Val(Test) = 0.10 Then
       "Number of blood specimens equal to 0.1%"
Else
   {ARTEST.Description}

your example 0.058, 0.083%, 0.117, 0.234, Not Analyzed, Not Detected, Positive, etc would return

Number of blood specimens below 0.1%

HTH



Gary Parker
MIS Data Analyst
Manchester, England

 

[TEM3]

Had to add the ()'s, but it worked great. Thanks!

Local stringvar Test := Left({ARRESULT.Result},5);

If {ARTEST.Description} = "Blood Alcohol %WT/VL" AND IsNumeric(Test) Then
(
If Val(Test) > 0.10 Then
"Number of blood specimens positive for > 0.1%"
Else If Val(Test) < 0.10 Then
"Number of blood specimens below 0.1%"
Else If Val(Test) = 0.10 Then
"Number of blood specimens equal to 0.1%"
)
Else
{ARRESULT.Result};