[RESOLVED] A Question About Crystal Reports

[xperator]

In Crystal why not just create a formula in the detail section of the report. I created this one. Make sure you use "Basic" instead of Crystal for the formula type:

Select Case {Table.Field}
   Case  1
        formula = "A"
    Case  2
        formula = "B"
    Case  3
        formula = "C"
    Case  4
        formula = "D"
    Case  5
        formula = "E"
    Case  6
        formula = "F"
   Case Else
      formula = "Out Of Bounds"
End Select

This will create a string based on the field being a certain number.

HTH

Actually the letter types are stored in another in the database. So i don't know which number indicates which one. But I have already saved them in an array in the main form. Is it possible to use that ?
Or maybe a way to do it using codes in the report form load event?

objRpt.DataDefinition.FormulaFields("LetterType1").Text = "'" & frmmain.LetterTypesList(, 1) & "'"

This is incomplete and I don't how to use the database field as the first argument in the array.