Help! Columnar Report with 3 Groupings?

[cf_aus]

Hi

I have sales data that needs to be grouped by Company, State and
Date. I would like to format the report as shown in image.

I am using Crystal Reports XI. I am new to Crystal Reports and
would like to find out whether this report is possible using either
columnar format or cross-tab???

Many Thanks

[thg]

Post a sample of your table(s). I can't help without knowing what you have to start with.

I have a feeling you'll need a crosstab

[cf_aus]

Hi

I have data in two tables - Sales and Dealers.

Sales
--------------------
DealerCode
WeekEnding
NumberSold

Dealers
--------------------
DealerCode
CompanyName
State

I have a command in Crystal as follows:

SELECT d.CompanyName, d.State, s.WeekEnding, s.NumberSold
FROM sales s
LEFT JOIN dealers d
ON s.DealerCode = d.DealerCode
AND s.WeekEnding BETWEEN '2006-04-01' AND '2006-04-30'

I would like to group the data returned by CompanyName, State and Date to get a Total of NumberSold.

I would like to format the report in columns (as in image attachment). I would also like to have a two week total and a week-on-week figure.

If you need any further info, let me know. Thanks for your help!

[Madhi]

Look for cross tab reports in help file