Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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