Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal often chooses the wrong feild types in excel, giving me a text when i want a number, how can i change it ?

Excel fields

Crystal often chooses the wrong feild types in excel, giving me a text when i want a number, how can i change it ?

by  ibearian  Posted    (Edited  )
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.

its a cheaty way out but it works
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top