Click here to Skip to main content
13,091,894 members (57,740 online)
Rate this:
Please Sign up or sign in to vote.
See more:
what i need is, In my crystal report i am grouping data by datetime value but in the group tree of my crystal repot the date is showing in the format yy:mm:dd..
I need to change this format to dd:mm:yyyy format...
Plz help me...

I am in a block, plz help me now...
Posted 25-May-11 0:18am
Updated 25-May-11 1:00am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If you are using Date field you can follow the below steps.

1. Right Click on the group date field.
2. Click Format Object
3. Goto Date Tab
4. Change to the format you need.
rahulrcn 25-May-11 6:28am
Didn't get what i need...
Sonal Wagh 9-Nov-12 4:01am
It formats date in group field, but group tree still shows default format, how to change date format in group tree
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Just go into the "Change Group" on the context menu and click the options tab.

Select the option for "use formula as group name" and use the
ToText ({tbl_XXXXXXXX.SpeciminDate},"dd-MMM-yyyy") or whatever format you wish.
Nelek 9-Nov-12 4:24am
Nice to have another option but... Did you noticed that the question is from May 2011?
Sonal Wagh 9-Nov-12 4:28am
i am new to crystal reports and had the same problem now, and just found the solution.
Nelek 9-Nov-12 6:59am
ok :) As I said, nice to have another option
version_2.0 26-Feb-13 7:06am
Thanks guys.. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100