the way i get round this is to have a hidden row at the top of the defined field. I create a new column called sort. My header/hidden row i give the value of 0 and all other rows a value greater, (normally 1). In each column put a number, date or text depending what i want crystal to classify this feild
ie
sort real real real real
hidden row 0 1 1 1-1-01 abc
First row 1 25.20 15.20 15-7-02 abccc
second row 1 17.21 12.10 15-7-02 defff
no matter what data is in you first real row it knows that they are number, number, date, text. Then to bin the hidden row from your results go into the selection expert (or what ever its called) select column 1 'SORT' = 1, this the eliminates the hidden row from your results.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.