Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Cross Tab Assistance Post Reply Post New Topic
Author Message
Lord Yorkshire
Newbie
Newbie
Avatar

Joined: 04 Jul 2010
Online Status: Offline
Posts: 28
Quote Lord Yorkshire Replybullet Topic: Cross Tab Assistance
    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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.