I have a crosstab table that produces Sales Stats for each customer over a
number of years listing the sales for each period across the page.
This works very well and I can produce totals at the bottom of the report.
However, the customer wants to see totals in much the same way as they are
printed for each customer, one grand total for each year for each month.
customer ABC
Jan Feb Mar Apr
2001 10 20 10 40
2002 15 16 20 16
2003 16 17 10 20
Customer
Totals 99 99 99 99
Grand Totals
2001 999 999 999 999
2002 999 999 999 999
2003 999 999 999 999
Is this possible? Perhaps with "Running Sum" ?
To me it seems an unreasonable request .... should really be a different
report ....
Any ideas anyone ?
thanks all,
jON
John Spencer - 01 Dec 2005 13:29 GMT
You are correct, it is a different report.
Build it as a different report and then use your summary report as a
SUB-report in the report footer (or some other group section) in your
original report.
>I have a crosstab table that produces Sales Stats for each customer over a
>number of years listing the sales for each period across the page.
[quoted text clipped - 30 lines]
>
> jON
Jon Rowlan - 01 Dec 2005 15:11 GMT
perfect Thanks John.
I will give it a go.
jON
> You are correct, it is a different report.
>
[quoted text clipped - 38 lines]
>>
>> jON