Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# CrystalReports
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
Edited 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 at 25-May-11 6:28am
Didn't get what i need...
Sonal Wagh at 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 at 9-Nov-12 4:24am
Nice to have another option but... Did you noticed that the question is from May 2011?
Sonal Wagh at 9-Nov-12 4:28am
i am new to crystal reports and had the same problem now, and just found the solution.
Nelek at 9-Nov-12 6:59am
ok :) As I said, nice to have another option
version_2.0 at 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
0 Sergey Alexandrovich Kryukov 355
1 _Amy 235
2 Peter Leow 185
3 Andreas Gieriet 180
4 Dave Kreskowiak 155
0 OriginalGriff 7,540
1 Sergey Alexandrovich Kryukov 6,462
2 Maciej Los 3,849
3 Peter Leow 3,653
4 CHill60 2,712

Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2014
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