Grouping by Week 2

[mwake]

I'm using CR 10 and my client wants a production report by week (Monday-Sunday) for multiple prior weeks. Since there is no "week" function, how do I create the weekly buckets for the production numbers?

 

[synapsevampire]

The standard way is to Group by the date, and select records will be grouped for each week, but the default is Sunday to Monday.

Create a formula to group on:

datepart("ww",{Orders.Required Date},crmonday)

-k