• Ideally, you would have someone fix the dirty data for you, and your problems would go away. But if that's not an option, you could create a calculated field in your report. Say we call it "TransactionType"

    =Switch(Fields!TransType.Value = "MO","Money Order",

    Fields!TransType.Value = "MnOrdr","Money Order",

    Fields!TransType.Value = "MOrdr","Money Order",

    Fields!TransType.Value = "MOrde","Money Order")

    Then all of the funky spellings will map to the same value. Then you would just use this expression ("TransactionType") instead of the original value.