Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Total column in Crosstab Post Reply Post New Topic
Author Message
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Topic: Total column in Crosstab
    Posted: 25 Apr 2010 at 12:32am

Hi,

I'm new in this forum and I always found the answer for the issue that I have in CR.
 
One question:
I have followed one of the article (or in other forum) about splitting the column by making only for 10 columns in a page.
So, if there are 17 columns, first page will print only the first 10 columns and the rest (7 columns) will print on next page.
 
My question is:
How to make column 'Total' only appear in the last page and its total for all columns (not for each 10 columns).
 
Thanks in advance for any helps/suggests.
 
emir
 
Emir W
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 26 Apr 2010 at 12:05pm
From the sound of your question I think you're using two separate cross-tabs - one for each page, correct?
 
If this is the case, go to the Cross-Tab Expert, Customize Style tab and check "Suppress Row Grand Totals" for the first cross-tab.
 
If that's not what you're doing, please explain.
 
-Dell


Edited by hilfy - 26 Apr 2010 at 12:05pm
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 27 Apr 2010 at 10:02pm

hilfy,

Thanks for the respond.
But that is not the case.
 
My issue is:
Whenever I run the report (crosstab) it gives me long pages because there are many columns.
So, I had to split the crosstab in few columns (e.g.: every 10 columns).
And it works.
But each crosstab will have each Total.
 
For example, there are 17 columns in the crosstab as shown below:
 
             col_1         col_2   ...    col_17                Total
row1     2               5      ...        7                       (2+5+...+7)
row2     5               10     ...       4                       (5+10+...+4)
.            .                .       ...        .                        .
.            .                .       ...        .                        .
row5     1               3      ...        5                       (1+3+...+5)
Total   (2+5+...+1)     .....          (7+4+...+5)      (total all)
 
 
After I split the crosstab every 10 columns it gives me like this:
 
(First crosstab)
             col_1         col_2   ...    col_10                Total
row1     2               5      ...        5                       (2+5+...+5)
row2     5               10     ...       3                       (5+10+...+3)
.            .                .       ...        .                        .
.            .                .       ...        .                        .
row5     1               3      ...        3                       (1+3+...+3)
Total   (2+5+...+1)     .....          (5+3+...+3)      (total all)
 
 
(Second crosstab)
             col_11       col_12   ...   col_17              Total
row1     4               8      ...        5                       (4+8+...+5)
row2     3               11     ...       3                       (3+11+...+3)
.            .                .       ...        .                        .
.            .                .       ...        .                        .
row5     2               5      ...        3                       (2+5+...+3)
Total   (4+3+...+2)     .....          (5+3+...+3)      (total all)
 
 
My question is:
How to remove column 'TOTAL' on first crosstab  and  print the column TOTAL only on second crosstab which is total from columns1, column2, ..., column17 ?
 
 
Thanks in advance for any suggestions and/or helps.
 
emir
Emir W
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 10 May 2010 at 7:37pm
hilfy,
 
I've followed what you've suggest for suppressing the 'TOTAL' column.
 
What I did is:
- suppressing TOTAL column for both crosstab (as in my example)
  and put the crosstab as a Group
- and make a summary crosstab for those Group which is contains the Total for both.
 
 
At this point it is work fine for me.
 
hilfy, thanks a lot for your time.
 
 
bunch of chocolates are in front of your door steps.
Big%20smile
 
Let's say "Case closed".
 


Edited by Emir_W - 10 May 2010 at 8:02pm
Emir W
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.