Skip to Content

grouping per number of days in a crosstab

Oct 14, 2016 at 03:50 PM


avatar image
Former Member

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?




10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Oct 14, 2016 at 03:51 PM

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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