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?

Crystal ReportsMicrosoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon
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
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

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.

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

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.

Ido Millet

Switch to SQL Native 11 instead of 10.

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.

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?

Mike McCracken

Why did you accept that comment as the answer?

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

Why OLE connection is not an option ?