Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Crosstab issue Post Reply Post New Topic
Author Message
SachinPawar
Newbie
Newbie


Joined: 01 Sep 2012
Online Status: Offline
Posts: 12
Quote SachinPawar Replybullet Topic: Crosstab issue
    Posted: 01 Sep 2012 at 11:40pm
Hi,
I have a query regarding data display in crosstab in Crystal Reports Designer XI.

I'm using a cross tab to display column data and its corresponding values in rows.
There are some row values which are split into two columns. I want to combine those row values defined for two columns into one column.

      ColA    ColB    ColC   ColD
RowA    1       2              3
RowB    23      33             5
RowC    21      11      4
RowD    44      3       77
RowE    88      8              9
RowF    66      3              2

In my above example I want to display the row values '3','5','9' and '2' of col D to appear in the same row but in col C and want to suppress col D
Can anyone help me!
Thanks in advance.

I could not find a way to attach a screenshot while posting this new topic which would help understanding my query.

Regards
Sachin

Edited by SachinPawar - 01 Sep 2012 at 11:53pm
IP IP Logged
SachinPawar
Newbie
Newbie


Joined: 01 Sep 2012
Online Status: Offline
Posts: 12
Quote SachinPawar Replybullet Posted: 02 Sep 2012 at 8:57pm
Can anybody help me?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Sep 2012 at 4:06am
If I understand you correctly, you want Column C to look something like this:  3, 5, 9, 2.  Is this correct or are you looking for the sum of these - 19 - to appear in the column?
 
Since the numbers appear in different rows based on how your cross-tab is configured, they would have to appear in a "Total" row of some sort.  Is that what you're looking for?
 
-Dell
IP IP Logged
SachinPawar
Newbie
Newbie


Joined: 01 Sep 2012
Online Status: Offline
Posts: 12
Quote SachinPawar Replybullet Posted: 04 Sep 2012 at 4:48am
Hi,

Thanks for your reply.
My existing report displays:

       ColA    ColB    ColC   ColD
RowA    1       2              3
RowB    23      33             5
RowC    21      11      4
RowD    44      3       77
RowE    88      8              9
RowF    66      3              2

I want to display the report as :

       ColA    ColB    ColC
RowA    1       2       3
RowB    23      33      5
RowC    21      11      4
RowD    44      3       77
RowE    88      8       9
RowF    66      3       2

Also I would like to highlight that
a) RowA, RowB, RowE and RowF are not associated with   
   ColC.
b) RowC and RowD are not associated with ColD.
c) ColA, ColB, ColC, and ColD are values of same field
   (say filed1) from a table and RowA, RowB, RowC, RowD,
   RowE and RowF are values of same fields (say field2)
   from the same table

I don't need any total for any of the columns.

Thanks
Sachin
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Sep 2012 at 5:33am
Ahh!  I think I understand now.
I think this can be done using Calculated Members, but  I haven't played with that functionality enough to be able to tell you exactly how it would work.
 
-Dell
 
IP IP Logged
SachinPawar
Newbie
Newbie


Joined: 01 Sep 2012
Online Status: Offline
Posts: 12
Quote SachinPawar Replybullet Posted: 04 Sep 2012 at 5:51am
Ohhhh!!!!

I saw some light in the dark but.....
Any ways, Could you please forward my request anybody in your contact or in this group who can help me out.

I'm at customer site where I'm stuck in this report and the customer is insisting for the same.

Thanks
Sachin
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.032 seconds.