Solved

Crystal Report 2008 Text data from SQL server not displaying

Posted on 2014-03-08
11
1,149 Views
Last Modified: 2014-04-22
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.
0
Comment
Question by:maverick0728
  • 3
  • 3
  • 2
  • +2
11 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
What datatype does the report thin the field is?

What datatype is the field in SQL2012?

What connection method are you using to connect the report to the database?

mlmcc
0
 

Author Comment

by:maverick0728
Comment Utility
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.
0
 
LVL 18

Expert Comment

by:vasto
Comment Utility
Start with Verify the database to make sure there is no mixes between the fields
0
 

Author Comment

by:maverick0728
Comment Utility
i have done 'verify database' and this doesn't change anything.  still same result.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Try using an OLE connection.

mlmcc
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
Switch to SQL Native 11 instead of 10.
0
 

Author Comment

by:maverick0728
Comment Utility
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?
0
 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
Try to use a command or a VIEW and CAST that column to a different data type.
0
 
LVL 34

Expert Comment

by:James0628
Comment Utility
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
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Why did you accept that comment as the answer?

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
Comment Utility
Why OLE connection is not an option ?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 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

9 Experts available now in Live!

Get 1:1 Help Now