?
Solved

Group by ODBC text converts text to number

Posted on 2004-08-24
11
Medium Priority
?
207 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
New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

 

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 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