Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
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?
Microsoft SQL Server
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-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 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
Try using an OLE connection.
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?
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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?
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!
Why OLE connection is not an option ?
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent