Column Headings & Data don't match in Crosstab report

[Bill Nguyen]

I used the following formula in my crosstab report.

WeekdayName (DayOfWeek ({selling.s_sell_date}),true,2) for column
and selling.sellGallons for the summarized value.

I wanted the week to begin with Monday (2), the colum heading display
correctly, but the data in the column came from Sunday instead of Monday's!

How can I fix this?
Thanks a million;
Bill

 

[Herfried K. Wagner [MVP]]

WeekdayName (DayOfWeek ({selling.s_sell_date}),true,2) for column
and selling.sellGallons for the summarized value.

I wanted the week to begin with Monday (2), the colum heading display
correctly, but the data in the column came from Sunday instead of Monday's!

If you don't get an answer here, you may want to give
<http://www.crystaldecisions.com/> a try.