Print Page | Close Window

Crosstab issue

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17476
Printed Date: 17 May 2024 at 9:12pm


Topic: Crosstab issue
Posted By: SachinPawar
Subject: Crosstab issue
Date 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


Replies:
Posted By: SachinPawar
Date Posted: 02 Sep 2012 at 8:57pm
Can anybody help me?

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: SachinPawar
Date 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

Posted By: hilfy
Date 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
 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: SachinPawar
Date 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


Print Page | Close Window