Print Page | Close Window

data type returned by sql expression

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4454
Printed Date: 28 Apr 2024 at 9:24am


Topic: data type returned by sql expression
Posted By: bctoben
Subject: data type returned by sql expression
Date Posted: 06 Oct 2008 at 6:26am
I'm a Crystal newbie trying to modify a report that is using SQL expressions.  I need 4 additional expressions that are basically identical to 4 that already work so I copied them.  The SQL database field referenced in the expression is a smalldatetime.  The original expressions return datetime information.  The ones I copied and modified are returning string data.  I don't find where the data gets formatted.  When I place the SQL expression on the report it goes as a string.  Viewing the original ones show datetime.
 
This is an original SQL expression.  I change the '11' to '31' in mine.
(Select "PED"."MP_StartDate"
 From PED
 Where "PED"."Deleted" = '0' and "PED"."MP_IP" = '11')
 
Thanks in advance for any assistance you can provide.


-------------
Brenda


Print Page | Close Window