Rolling period rpt, crystal 8.5 pls help

[samroll]

I have a rpt with 4 params:
Division, Region, Market , Period
running off a stored procedure.

The rpt should give me totals for the period selected by the user and that works fine.

This is the problem:
The report also needs to display the previous 11 periods and their totals to the right of the period seleced by the user.

For example: If the user selects "DEC 03", it should display the following:

Dec 03 Nov 03 Oct 03 Sept 03 Aug 03 and so on...
(totals) (totals) (totals) (totals) (totals)

Please help if you can. thanks, sam

[harmonycitra]

Hi,

Have you tried Cross Tab report. It'll solve your problem. You can create group for period and for every month.

Regards,
harmonycitra