Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: DateTime conversion Post Reply Post New Topic
Author Message
naresh_katakam
Newbie
Newbie


Joined: 15 Aug 2009
Online Status: Offline
Posts: 4
Quote naresh_katakam Replybullet Topic: DateTime conversion
     Posted: 15 Aug 2009 at 8:43am
Hi All,

I'm new to CR and started working on CR2008. I have DateTime field from Oracle DB and need to format it to show only Date in format mm/dd/yyyy in the report. Please help me as how can this be formatted.
Also, I need to create dynamic group on this Date field.
We need have 2 groups Cust No and Date. Based on the user input as Cust No or Date, need to group the report data dynamically.
Thanks
Naresh
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 16 Aug 2009 at 10:06am

To format the field - right click on it and select "Format..." Go to the Date/Time tab and select a format that contains only the date.

For the group, right-click on the date group header, select "Change Group", set it to print for "Every Day".
 
-Dell
IP IP Logged
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