Date in group header and group footer different 1

[patty1]

Does anyone know why the formula in Group1 header brings down Monday's date and the one in Group1 Footer brings down Friday's date. I would like them both to be Friday's.


Formula in Group1 header
"Week Starting: " + totext(date({Transaction_History.Post_Date}), "MM/dd/yyyy&quot

Formula in Group1 Footer
"Week Ending: " + totext(date({Transaction_History.Post_Date}), "MM/dd/yyyy&quot + " " + "Sub Total"

 

[IdoMillet]

The Group Header shows data from the FIRST record in that group. The Group Footer shows data from the LAST record in that group.

If the data is sorted my dates, you can always show in the Group Header the maximum date using a formula such as:
----------------------------------------------
Maximum({your_date_field}, {your_Group_Field})
----------------------------------------------

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[patty1]

If is saying that the field cannot be summarized.

Maximum(GroupName ({Transaction_History.Post_Date}, "weekly&quot)

 

[IdoMillet]

Sounds like you are grouping on a date field with a weekly option. Hence, you need to use something like:
---------------------------------------
Maximum ({Transaction_History.Post_Date}, {Transaction_History.Post_Date}, "weekly&quot
---------------------------------------

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[patty1]

Thank you so much!!