Hi I have a field returned in my dataset of type text or string. I wish to sort on these fields and need to split them.
eg. I might have a data set such as
I need to stay away from stored procedures in that I don't have access to the server, but In reportviewer I could set a field expression like:
This works until there is nolonger a field in the array where I get #Error
Does anyone know an expression I can use on each of these fileds to handel this error and perhaps replace with a "00" so that it sorts correctly.
Your imeediate assitance is appreciated!