Skip to Content
0
Former Member
Jun 11, 2009 at 07:58 PM

Crystal converting string fields to number fields

33 Views

I'm attempting to add a SQL stored procedure (SQL Server 2005) to a new report using the Database Expert wizard. The procedure has fields defined as number, datetime and string. It adds into the report fine, but all the fields end up defined as numbers in VS. Dragging a datetime or string field onto the report workspace clearly shows them to be number fields. I cannot convert them to anything else. Why is Crystal overriding the datatype definition from my SQL result set and making every field a number?

I'm using Crystal Reports that is integrated with Visual Studio 2005 (Version 8.0.50727.42) with MS .NET Framework (Version 2.0.50727 SP2).