Format Drill Down

[pgmr]

Hi,
Cr 8.5 ODBC to AS400.
My report lists Po#, quantity, $$ total and cancel date.
I am grouping by cancel date and have summaries for $$ and quantities based on cancel date. The format of the cancel date is YYYYMMDD which sorts correctly. I changed the group header to show this date as mm/dd/yy.
My problem is the drill down section where the user would select the cancel date to see more detail is YYYYMMDD.
Anyone know where I change it to display a friendlier date.
Thanks

 

[pgmr]

Sorry to be more clear.
I need to format the date in the group tree.

 

[pgmr]

In case someone else need the info.
Report->Change Group Expert->Options->
Customize Group Name Field->Use formula as group name