[RESOLVED] Developer Express XtraReports - Crystal Reports

If anyone uses developer express reports, and knows how to have formulas for text fields in their reports ( like crystal reports formulas ) this would be a great help.

ex crystal:

Code:

---

IF {rpt_Code.Category} = "AG" THEN
    "AG - Agriculture"
ELSE
IF {rpt_Code.Category} = "IR" THEN
    "IR - Interest Rate"
ELSE

---

U have to use the beforeprint event in the report code. For ex. i have this to put the right suffix behind a ranking:

Code:

---

    Private Sub replRank_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs) Handles replRank.BeforePrint
        If CInt(GetCurrentColumnValue("Rank")) = 1 Then
            CType(sender, XRTableCell).Text = "1st"
            CType(sender, XRTableCell).ForeColor = Color.Green
        ElseIf CInt(GetCurrentColumnValue("Rank")) = 2 Then
            CType(sender, XRTableCell).Text = "2nd"
            CType(sender, XRTableCell).ForeColor = Color.DarkGreen
        ElseIf CInt(GetCurrentColumnValue("Rank")) = 3 Then
            CType(sender, XRTableCell).Text = "3rd"
            CType(sender, XRTableCell).ForeColor = Color.DarkGreen
        Else
            CType(sender, XRTableCell).Text = CType(sender, XRTableCell).Text & "th"
            CType(sender, XRTableCell).ForeColor = Color.Black
        End If
    End Sub

---

Thats what I thought, didn't know which script to put it in. Thanks for the help.

Its funny I got a response here before I did on the DevExp. forums.