×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Objects: Crystal Reports 2 Data Access FAQ

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: 16 Jul 02

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

Back to Business Objects: Crystal Reports 2 Data Access FAQ Index
Back to Business Objects: Crystal Reports 2 Data Access Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close