Include complete week in Crosstab only if it begins in that month

[cwarner]

My record selection includes data for multiple months (example: 1/1/20 - 7/7/20).

I have a crosstab grouped by months (in the Group header of report, so it shows a crosstab for each month separately).

I would only like to include the week for that month if it "begins" in that month. However, I would like to include ALL the counts for that week even if it runs into the next month.

Example: June should NOT include week of 5/31/20. However, June should include all data for the week of 6/28 - 7/4.

How would I accomplish this?

Thanks for any help!

[DellSC · Accepted solution]

Instead of grouping on the month from the date field, I would create a formula that will return the first day of the week and use that for grouping.

{vwVouchInfo.Voucher_Service_Date} - DayOfWeek({vwVouchInfo.Voucher_Service_Date}) + 1

Use this for your crosstab columns instead of the date field.

-Dell

[cwarner · Accepted solution]

Works great! Thanks, Dell!