Skip to Content
Former Member
Oct 14, 2016 at 03:50 PM

grouping per number of days in a crosstab

58 Views Last edit Sep 04, 2017 at 09:40 AM 2 rev

Dear Experts,

I have created a crosstab in Crystal Report with Date as columns and Operating Expense Name as rows, I also set a parameter to get the transactions in between dates.

now what i need to do is group the results on a per week basis, it would be easy if it would be just a normal week but its not. like for example week 1 is 4-11, week 2 is 12-18 and sometimes it will be week 1 is 5-12, week 2 13-19, etc.

how can i group the results of the column per week or 7 days based on the date parameters?