Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1255
  • Last Modified:

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.
0
maverick0728
Asked:
maverick0728
  • 3
  • 3
  • 2
  • +2
1 Solution
 
mlmccCommented:
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
 
maverick0728Author Commented:
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
 
vastoCommented:
Start with Verify the database to make sure there is no mixes between the fields
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
maverick0728Author Commented:
i have done 'verify database' and this doesn't change anything.  still same result.
0
 
mlmccCommented:
Try using an OLE connection.

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Switch to SQL Native 11 instead of 10.
0
 
maverick0728Author Commented:
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
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Try to use a command or a VIEW and CAST that column to a different data type.
0
 
James0628Commented:
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
 
mlmccCommented:
Why did you accept that comment as the answer?

mlmcc
0
 
vastoCommented:
Why OLE connection is not an option ?
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now