Total column in Crosstab
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=9808
Printed Date: 05 May 2024 at 3:27am
Topic: Total column in Crosstab
Posted By: Emir_W
Subject: Total column in Crosstab
Date 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 |
Replies:
Posted By: hilfy
Date 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 ------------- 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: Emir_W
Date 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 |
Posted By: Emir_W
Date 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.
 Let's say "Case closed".
------------- Emir W |