Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: data type returned by sql expression Post Reply Post New Topic
Author Message
bctoben
Newbie
Newbie
Avatar

Joined: 06 Oct 2008
Location: United States
Online Status: Offline
Posts: 1
Quote bctoben Replybullet Topic: data type returned by sql expression
    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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.