• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Group by ODBC text converts text to number

My CR 8.5 report uses ODBC text driver: ODBCJT32.DLL (4.00.6019.00). On my XP development machine the report groups correctly ie: (SL01, SL02, RW01, etc)  On the '98 workcenters useing the same dll the group changes to (1.00, 2.00 ect).  So the SL01 and the RW01 get combined into the same group.  Any ideas?? Thanks
0
dgoncher
Asked:
dgoncher
  • 4
  • 3
  • 2
  • +1
1 Solution
 
mlmccCommented:
On the Win 98 machines you may need to revert back to an older driver.  The one you are using may not be fully compatible with Win98.

mlmcc
0
 
dgoncherAuthor Commented:
I copied an older version of the dll, same problem
0
 
frodomanCommented:
This is identical report?  Identical data?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
dgoncherAuthor Commented:
The same report.  Same data
0
 
mlmccCommented:
Do you have a Win98 machine you can install Crystal to temporarily and see if you still get the same problem?

mlmcc
0
 
dgoncherAuthor Commented:
I've installed the CR8.5 on the 98 machine.  Same results.
0
 
dgoncherAuthor Commented:
I have discovered that the appilicatioon that writes to the text file was deliminating by comma, but not encapsulating text with double quotes.  Even though the field in question always began with a character, the report or the ODBC on the 98 machines still interpreted it as a number. Once the program was mofdified the report ran as designed.  

Thanks for you thoughts
0
 
frodomanCommented:
Interesting.  

Since we couldn't help you I'm sure you'll request a point refund.  I'd like to ask that you request PAQ / Refund instead of Delete / Refund though because this info may be helpful to others in the future.

Cheers,

frodoman
0
 
mlmccCommented:
Agree with frodoman.  Also that problem is something we probably would never think of.

mlmcc
0
 
DarthModCommented:
Submitted to PAQ with no points refunded (of 250)

DarthMod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now