Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maverick0728

ASKER

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.
Avatar of Mike McCracken
Mike McCracken

Try using an OLE connection.

mlmcc
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?
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?

 James
Why did you accept that comment as the answer?

mlmcc
Why OLE connection is not an option ?