Skip to Content
0
Former Member
Aug 03, 2012 at 08:31 PM

Cross Tab Report - would like to group product weekly using a formulae ?

157 Views

Hi Everyone,

I am working on a Crystal Report which need to be setup as a crosstab report in order to pull the data the way I want to display it. While I understand how they work I am looking for some guidance on how to customize the column rows along the top of the cross tab report.

What I want to achieve is for the report to look at the items have been ordered by sales in the previous 4-6 week and then to break down how much qty of each product was ordered weekly and show this in a cross tab report.

so very simply as an example

WK 1 WK 2 WK 3 WK 4

Basket of Apples 2 4 1 6

Basket of Oranges 1 2 1 3

At the moment if I use the cross tab report wizard - I can break them down weekly either by the first day of the week or the last day of the week.

Is anyone familar with writing a forumlae for setting a data range by dates so for example i would like to be able to set the date ranges for each week so I can

set the date range for each week - and name each week as WK31,WK32,WK33 and so on.

Basket of Apples 2 4 1 6

Basket of Oranges 1 2 1 3

any suggestions would be greatly appreiciated

best regards

Paul