cancel
Showing results for 
Search instead for 
Did you mean: 

grouping per number of days in a crosstab

Former Member
0 Kudos

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?

Thanks!

Regards,

Carlo

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Just to confirm, are you using CR for Business One? It does make a difference....

Don

Former Member
0 Kudos

yes sir, i am using Crystal Report 2008 for SAP Business One