This is a migrated thread and some comments may be shown as answers.

Averaging Data

1 Answer 96 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Michael DeBerry
Top achievements
Rank 1
Michael DeBerry asked on 21 Jan 2010, 04:20 PM
I am converting some of our active reports and ran into an issue, It is not really a porting issue but may be more of a life cycle question.

I have a detail section for a group that has the following
[hidden Sum(ServiceCount)]  [ServiceType] [ ServiceCount ] [ServicePercentage] [ TotalPrice ]
where the first item is a hidden textbox

in active reports the following would be generated
[15] [Service1] [ 5 ][ 5/15 = 33.3%][100]
[15] [Service2] [10][10/15 = 66.7%][200]
================================ group footer
                         15                          300

For the active report the percentage is calculated in the equivalent to the item data bound event for the detail section. The sum is placed in the hidden field so that it is accessible during the event.

in telerik I get the following, using the same procedure that was take with the active report.
[ 5 ] [Service1] [ 5 ][ 5/5 = 100% ][100]
[10] [Service2] [10][10/10 = 100%][200]
================================ group footer
                         15                          300

I could possibly do the calculation in the report databound event and loop through all the groups to perform the update but I am wondering is there a better way of handling this.

Thank you

1 Answer, 1 is accepted

Sort by
0
Michael DeBerry
Top achievements
Rank 1
answered on 21 Jan 2010, 06:23 PM
I was able to accomplish this by looping through the detail sections of the group in the footer databound event. This solution isn't that bad but I am still wondering if there is a better way

Thank you
Tags
General Discussions
Asked by
Michael DeBerry
Top achievements
Rank 1
Answers by
Michael DeBerry
Top achievements
Rank 1
Share this question
or