CROSS TABS for each week grouping

[coffee123]

Greetings people

Problem. I have created a crosstab report. I am grouping cross tabs on date field with the "each week" group option. BUT here come the problem the date the crosstab defaults to the nearest sunday. Not good.

I want it to be a first monday. ie Sunday + 1 day. in a formula or something

is this possible?

thanks

 

[IdoMillet]

Create the following formula:
----------------------------------------
DatePart ("ww",{your_date_time_column} , crMonday)
----------------------------------------
It returns the week number where weeks start on Monday.

If your column is Date Type (rather than DateTime),
use the following formula:
----------------------------------------
DatePart ("ww",CDateTime({your_date_column}) , crMonday)
----------------------------------------

Then, use this formula as your CrossTab grouping.

Cheers,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:

http://www.MilletSoftware.com