Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR Group Footer Date Format Problem

Status
Not open for further replies.

crdamsel

Programmer
Aug 7, 2013
33
US
Have a problem with the data format in a Group Footer. The date is supposed to be YYY-MM-DD in the Group Footer total but when it is the first line in a next page, it changes to M/DD/YYY as shown below:

HEADING
PH =======
-----------------------
GF1 Total for 6/30/2004
GH Example
-----------------------
GF1 Total for 2004-07-31

So does anyone know how to keep the date format consistent in the Group Footer from page to page?
 
In 18 years of Crystal I have never seen an object change format from one page to the next without something telling it to change.

What version of CR are you using?
Does this happen when you run the report from within Crystal Reports or when run through another application?
If you right click on the object in preview and set the format, does that fix it?


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
 
Appreciate your immediate reply. I am using CR 2011 however it only does it if i use the Group Name Field in the Group Footer but when i used a Database Field in the Group Footer, the date format did not change so i was able to solve my problem. Still, thanks again for your response. This thread can be considered closed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top