Click here to Skip to main content
15,881,027 members
Search within:


How to change the format of Group tree grouped by datetime in to dd:mm:yyyy format
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Updated 25-May-11 1:00am
v4
Add a Solution

2 solutions

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.
 
Share this answer
 
Posted
Comments
version_2.0 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
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.
 
Share this answer
 
Posted
Comments
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.. :)
Add a Solution

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
Related Questions
How I manage system date formate dd/MM/yyyy and MM/dd/yyyy?
How to convert datetime in the format dd/MM/yyyy hh:mm:ss:tt to yyyy/MM/dd hh:mm:ss tt in ASP.NET with C#?
Convert MM/dd/yyyy format to small datetime format
changing date format from dd/MM/yyyy to date format MM/dd/yyyy
Datetime can't be change to other format [dd/MM/yyyy] to [MM/dd/yyyy],[yyyy/MM/dd],... like that
How to change date format from mm/dd/yyyy to dd/mm/yyyy
How to Change Dateformat from DD/MM/YYYY to YYYY/MM/DD
converting datetime to yyyy/MM/dd format.
Requrement for Date Format (dd/MM/yyyy)
Convert date format from MM/dd/yyyy to dd/MM/yyyy

Advertise
Privacy
Cookies
Terms of Use
Last Updated 9 Nov 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900