Solved

Group by ODBC text converts text to number

Posted on 2004-08-24
11
196 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

757 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now