Calculate Percentage in the main report, getting values from the subreport

I have 2 reports: Main report (let's call it 'Main'), Subreport (let's call it "Sub")
 
Report Main contains Sub report in detailed band. Below is the report structure:
 
Column A              Column B                     Column C
a1                             b1                                   c1
                                  b2                                   c2     
                                  Total1                             c1 + c2
                                  %Total                            Total1 / (c1 + c2 + c3 + c4)
a2                             b1                                    c3
                                  b2                                    c4
                                  Total2                              c3 + c4
                                   %Total                           Total2 / (c1 + c2 + c3 + c4)
 
I want to calculate %Total in main report. 
I have followed below steps : 
1. Created variable "sum at report level" in the main report which is c1 + c2 + c3 + c4 from subreport.
Properties :
1. Calculation : Sum
2. Increment type: None
3. Reset type : Report
The value for this variable I am able to get it.
2. Created variable "sum at band level" in the main report which is Total1 or Total2 from subreport.
Properties :
1. Calculation : Sum
2. Increment type: None
3. Reset type : Page
The value for this variable I am not getting it somehow. 
3. Created variable %Total in the main report which is sum at band level/sum at report level
Properties :
1. Calculation : No Calculation
2. Increment type: None
3. Reset type : Report
The evaluation time of the text field where I am displaying the value of %Total is set to "Auto"
 
I am not getting correct percentage value. I have tried setting different evaluation time. Is it possible to reset the variable at band level? Or any other way to calculate percentage?
 
yamini_nawlani's picture
Joined: Jun 20 2016 - 4:00am
Last seen: 6 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness