Click here to Skip to main content
Rate this: bad
good
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
v4
Rate this: bad
good
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.
  Permalink  
Comments
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
good
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.
  Permalink  
Comments
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 CHill60 185
1 Sarvesh Kumar Gupta 185
2 OriginalGriff 179
3 George Jonsson 154
4 ArunRajendra 144


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid