Skip to Content
avatar image
Former Member

grouping per number of days in a crosstab

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 14, 2016 at 03:51 PM

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

    Don

    Add comment
    10|10000 characters needed characters exceeded