Select Case formula in CR

[MacroAlan]

For a heading on a report, the client wants one of 4 headings to appear. This is my first Select Case and I am confused:

select [highlight]case[/highlight] {tracking_file.Program_Suffix}
case "N"
    select case {tracking_file.f463#loan_status}
        case "A"
            formula="Approved Purchase"
        case "S"
            formula="Submitted Purchase"
    end select
case "Y"
    select case {tracking_file.f463#loan_status}
        case "A"
            formula="Approved Refi"
        case "S"
            formula="Submitted Refi"
    end select  
case else  
end select

I am getting errors I don't understand. It is highlighting the first 'case' word.


Alan

 

[briangriffin]

Looks like you've written the formula using Basic syntax, but have selected Crystal syntax in the dropdown menu in the formula editor.

Either change the dropdown to Basic syntax, or eliminate the "case" word from the select lines of the formula, which are not needed in Crystal syntax.

Crystal help has several examples of each.

 

[lbass]

Crystal syntax:

select {tracking_file.Program_Suffix}
case "N" :
(
select {tracking_file.f463#loan_status}
case "A" : "Approved Purchase"
case "S" : "Submitted Purchase"
)
case "Y" :
(
Select {tracking_file.f463#loan_status}
case "A" : "Approved Refi"
case "S" : "Submitted Refi"
)

-LB

 

[GJParker]

Crystal syntax: If,Then,Else example

If {tracking_file.Program_Suffix} = "N" Then
If {tracking_file.f463#loan_status} = "A" Then
"Approved Purchase"
Else //If {tracking_file.f463#loan_status} = "S" Then
"Submitted Purchase"
Else //If {tracking_file.Program_Suffix} = "Y"
If {tracking_file.f463#loan_status} = "A" Then
"Approved Refi"
Else //If {tracking_file.f463#loan_status} = "S" Then
"Submitted Refi"


Gary Parker
MIS Data Analyst
Manchester, England