Solved

Group by ODBC text converts text to number

Posted on 2004-08-24
11
200 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
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 100

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

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

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 100

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports 11 Ignoring Parameters 3 81
Crystal Reports Subreport details 16 58
Crystal Report detail 15 49
Sum of multiple formulas 6 19
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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