Solved

Group by ODBC text converts text to number

Posted on 2004-08-24
11
204 Views
Last Modified: 2012-05-05
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
Comment
Question by:dgoncher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 11881088
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
 

Author Comment

by:dgoncher
ID: 11881972
I copied an older version of the dll, same problem
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11882022
This is identical report?  Identical data?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:dgoncher
ID: 11882074
The same report.  Same data
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 11884588
Do you have a Win98 machine you can install Crystal to temporarily and see if you still get the same problem?

mlmcc
0
 

Author Comment

by:dgoncher
ID: 11893192
I've installed the CR8.5 on the 98 machine.  Same results.
0
 

Author Comment

by:dgoncher
ID: 11895474
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
 
LVL 42

Expert Comment

by:frodoman
ID: 11896222
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 11898841
Agree with frodoman.  Also that problem is something we probably would never think of.

mlmcc
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 12142379
Submitted to PAQ with no points refunded (of 250)

DarthMod
Community Support Moderator
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question