Chart (X) Axis date display not matching group display for start date

[Former Member]

Hello,

I have a report which groups by week with starting day monday and week ending sunday. The data is grouped off a formula

Formula: GroupWeekStartMon

 {zemptyrepo_.LgStrDt}-DayOfWeek ({zemptyrepo_.LgStrDt},crMonday )+1 

This works perfectly, the issue is current the report groups and shows the start date for the week (monday)

e.g

21/11/2011 $982928

14/11/2011 $298290

07/11/2011 $726727

The chart, which also uses Formula: GroupWeekStartMon displays

20/11/2011

13/11/2011

07/11/2011

Basicaly i need the chart dates to match the report dates..

any ideas?

[Former Member]

I assume the Xtab ( for the chart) is using it's own week.

I can't see a way to fix this.

the only option is to create a forumula for each record as a text with the date you want to display and use this then you don't do date grouping.