Avatar of maverick0728
maverick0728Flag for United States of America asked on

Crystal Report 2008 Text data from SQL server not displaying

I have data coming over from SQL 2012 into Crystal 2008.  Most of the part numbers are numeric, but some of them begin with alpha characters.  The ones that begin with alpha characters do no display.  

Also, I have some fields with a 0 or 1 in them and when I use the record select expert, they show $- or $1 for the data.  Why are they not just 0 or 1?

Thanks.
Crystal ReportsMicrosoft SQL Server

Avatar of undefined
Last Comment
vasto

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
maverick0728

The blank text field, has data type = string[50] in crystal, and varchar(50) in SQL
The logical field, has data type = Number in crystal, and tinyint in SQL

I am using an ODBC connection with SQL Server Native Client 10.0 as the driver.
vasto

Start with Verify the database to make sure there is no mixes between the fields
ASKER
maverick0728

i have done 'verify database' and this doesn't change anything.  still same result.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Mike McCracken

Try using an OLE connection.

mlmcc
Ido Millet

Switch to SQL Native 11 instead of 10.
ASKER
maverick0728

mlmcc - we cannot use a OLE connection.
IdoMillet - I tried the SQL Native 11.0 connection and I get the same result.  Any other suggestions?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Ido Millet

Try to use a command or a VIEW and CAST that column to a different data type.
James0628

Is the report just reading the table(s) directly, or are you using something like a view or stored procedure that might be manipulating the data before it gets to CR?

 James
Mike McCracken

Why did you accept that comment as the answer?

mlmcc
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
vasto

Why OLE connection is not an option ?