Cross Tab Assistance
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=22866
Printed Date: 03 May 2024 at 4:23pm
Topic: Cross Tab Assistance
Posted By: Lord Yorkshire
Subject: Cross Tab Assistance
Date Posted: 17 Apr 2020 at 1:31am
I would really appreciate some help on a report that has me stumped.
I use Crystal Reports Version 11.5.10.1263
I am doing a report to show price tables for several customers.
an example of the Data would be as follows
Item 123 :
Price Date 01/01/2019 5,000 = 219.00
Price Date 01/01/2020 3,000 = 300.00
Price Date 01/01/2020 4,000 = 250.00
Item ABC
Price Date 01/01/2020 10,000 = 150.00
What i am getting in the cross tab is
01/01/2019 01/10/20
5000 3000 4000 10,000
Item 123 5000 219.00 3000 300.00 4000 250.00
Item ABC 10,000 150.00
I have fiddled it get this far, so i am thinking i am not going down the right path. When i say Fiddled It, the cross tab summarised fields are the sum of... So if i take the quantity breaks out of the columns if 550 instead of 300 & 250.
How i would like the report to look is
01/01/2019 01/01/20
Item 123 5000 219.00 3000 300.00 4000 250.00
Item ABC 10,000 150.00
This is just a small section of data but we can have up to 20 different quantity breaks.
Ultimately this will end up in an excel report, so they dont want it vertical, they need it horizontal.
Any suppport. advice, direction would be appreicated.
|
Replies:
Posted By: hilfy
Date Posted: 20 Apr 2020 at 5:33am
I don't think there's a way to do this directly in Crystal, although I can think of a way you might be able to handle it in a Command (SQL query).
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|