I wish to retrieve data from a particular database field via Crystal, only I want to trim the data that comes in, and report against this data.
Ex. I am pulling in data from a field called REFERENCE, and it gives me a value of 30101301. I only want to display and work with the first three numbers here: '301'. I also want to do a lookup using this number, to another table that provides a correlating description for what 301 is.
Anyone know the SQL Statement or steps in Crystal to do this?