Crystal Reports If Any Record Meets Condition, Exit Formula -

Crystal Reports If Any Record Meets Condition, Exit Formula -

i wish create formula read each record, , if status met formula stop reading records , homecoming specific label. have tried next code , right result displayed @ detail level not footer. appears "exit for" isn't working. help!

current code (i have placed in study footer):

shared stringvar label := ""; local numbervar i; := 1 {#count_records} ( if ({report_data.return_code}[i] = "defective-exchange" or {report_data.return_code}[i] = "defective") label := "defective-exchange only"; exit for; ); if label = "" label:="pickup credit memo"; label;

to eliminate data, utilize record-selection formula:

{report_data.return_code} = "defective-exchange" or {report_data.return_code} = "defective"

to format data, utilize formula field:

// {@return code} if {report_data.return_code} = "defective-exchange" or {report_data.return_code} = "defective" "defective-exchange only" else if {report_data.return_code} = "" "pickup credit memo" else "something else"

crystal-reports