how to add percentage total below the total entry..

can somebody help me how can i add percentage per column of the total and result total also as 100%


see the image attached..

Code:

---


Month      Playing              Reading                      Total          Percentage
1              1                        2                            3                17.65%
2              1                        3                            4                23.53%
5              2                        2                            4                23.53%
4              1                        2                            3                17.65%
8              2                        1                            3                17.65%
Total          7                        10                          17              100%
% total    (41.18%)              (59.82%)                  (100%)

---

those bold line i want to add it... please help me how? please see the status of my report in the image..

Try with SubReports
Could be :
the main report calculate the total,
detail section suppressed,
insert a subreport (your actual report) at report footer section using the total from the main report thru linked variables

how can i make it percentage format.. and how can i make the result the as what i wanted to do in post # 1?

how can i make it with percent sign... i have already the field that count the activity per month but i only get the value not the percentage equivalent..

vb Code:

mymonth         Playing        Reading       Total       Percent      
   1                    1                  3               4           57.41%          
   2                    2                  1               3           42.85% 
  Total               3                   4               7            100% 
Percent            42.85%           57.41%       100%

i've tried subreport but i only get the same value as the images i've attached in the post # 1.. please help me how can i make it done here...

any help please?

Which version of Crystal are you using? Is this a Cross-Tab report?

If you are using Crystal 9 or above you should be able to add the Percentages directly to the Cross Tab report.

im using version 9