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 1:18am
Edited 25-May-11 2: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 Peter Leow 255
1 Mika Wendelius 240
2 Zoltán Zörgő 198
3 CHill60 195
4 TheRealSteveJudge 180
0 Sergey Alexandrovich Kryukov 8,698
1 OriginalGriff 6,591
2 Peter Leow 3,982
3 Zoltán Zörgő 3,634
4 Richard MacCutchan 2,535

Advertise | Privacy | Mobile
Web04 | 2.8.150123.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2015
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