Column Headings & Data don't match in Crosstab report

  • Thread starter Thread starter Bill Nguyen
  • Start date Start date
B

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
 
* "Bill Nguyen said:
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!
Click to expand...

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