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 ThanksPost 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|||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!|||Look for cross tab reports in help file
Friday, March 9, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment