Print Page | Close Window

Cross-Tab Columns

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10601
Printed Date: 05 May 2024 at 1:49am


Topic: Cross-Tab Columns
Posted By: upndown4par
Subject: Cross-Tab Columns
Date Posted: 21 Jul 2010 at 8:39am
Hi,

I have data that is being retrieved like "Table A" below and want to put it into a Cross-Tab.  There could be any number of Dates so that's why I'm using the Cross-Tab.  I would like the Cross-Tab to look like Cross-Tab Results (below) but can't seem to figure out how to do it.  I'm guessing that it can be done but none of the books I've looked through are showing what I would like.

Any ideas, help and/or suggestions will be greatly appreciated.

Thanks in advance.

Ron

Table A
Date
Customer
Product Amt
4/23/2010
Acme
A1 $200
4/23/2010
Acme
B2 $100
4/23/2010
Smithco
A1 $200
4/23/2010
Smithco
B2 $200
4/30/2010
Acme
A1 $75
4/30/2010
Acme
B2 $100
4/30/2010
Smithco
A1 $200
4/30/2010
Smithco
B2 $75
5/7/2010
Acme
A1 $150
5/7/2010
Acme
B2 $200
5/7/2010
Smithco
A1 $150
5/7/2010
Smithco
B2 $150
5/14/2010
Acme
A1 $100
5/14/2010
Acme
B2 $200
5/14/2010
Smithco
A1 $300
5/14/2010
Smithco
B2 $100


Cross-Tab Results
Customer Product 5/14/2010 5/7/2010 4/30/2010 4/23/2010
Acme A1 $100 $150 $75 $200
  B2 $200 $200 $100 $100
Smithco A1 $300 $150 $200 $200
  B2 $100 $150 $75 $200



Replies:
Posted By: Emir_W
Date Posted: 21 Jul 2010 at 8:44pm
try to help.
 
you can create a crosstab with:
- 2 rows (Customer and Product)
- 1 column (Date)
   click on 'Group Options' to set the Sorting option
- Summarizeds fields (count of Amt)
 
 
and you can modify the layout in 'Customize Style' tab.
 
 
hope it help.
 


-------------
Emir W


Print Page | Close Window