HOW Can I do this with Crystal 8.5 ??

[krist]

Hi,
I have a requirement to create 'Weekly Sales Report', a report with variable number of columns, with Crystal Rpt 8.5 .
below is the layout :
1) on first week of the month, the report will look like :
Customer Sales_Week_1
---------------------------
abc 9,999

2) on second week of the month, the report will look like :
Customer Sales_Week_1 Sales_Week_2
--------------------------------------------
abc 9,999 9,999

3) on third week of the month, the report will look like :
Customer Sales_Week_1 Sales_Week_2 Sales_Week_3
--------------------------------------------------------
abc 9,999 9,999 9,999
and so on..

The number of the weeks in a month could be different from month to month, between 4 to 5.

How can I do this with Crystal 8.5 ?
(assuming the data to be printed is already calculated in a Stored Procedure)

thanks in advance,
Krist

 

[JustineB]

Hi!
The way that I would do this would be by conditionally suppressing columns 2 - 5. I would suppress them according to the date in the month. Check out the "DateDiff" function.

 

[jgirardi]

A cross tab report would be
your solution.