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

Grouping with SUM in footer

2 Answers 50 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jon
Top achievements
Rank 1
Jon asked on 22 Feb 2013, 04:18 PM
Hi,

I maybe doing something stupid or missing something here.

I've done a simple example 

Data coming in:

a 2 xwef
a 2 uybvu
a 2 guyvbfu
b 2.3 likubnil
b 2.3 lik43535
b 2.3 likub54543
b 2.3 gfwerg

With grouping based on first 2 values and the detail showing the 3rd value I want and get the following.
a      2
xwef
uybvu
guyvbfu

b 2.3 
likubnil
lik43535
likub54543
gfwerg

No I want to add a total at the bottom, I've done as SUM(2nd field)  the net result is 3 * 2 + 4 * 2.3,  It should be 2 + 2.,3

How should I get that?

Thanks for any help

Regards

Jon

2 Answers, 1 is accepted

Sort by
0
Petio Petkov
Telerik team
answered on 27 Feb 2013, 02:50 PM
Hi Jon,

You may create a custom aggregate function as described in the User Aggregate Functions help article.
Find attached a sample report similar to your scenario. The DistinctSum custom aggregate function is used in Report1 against the AdventureWorks database.

Hope this helps.

Kind regards,
Petio Petkov
the Telerik team

See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

0
Jon
Top achievements
Rank 1
answered on 27 Feb 2013, 02:55 PM
Many thanks Petio.  I managed to do it using the various data binding events.  I'll have a look at this for future work though,

Regards

Jon
Tags
General Discussions
Asked by
Jon
Top achievements
Rank 1
Answers by
Petio Petkov
Telerik team
Jon
Top achievements
Rank 1
Share this question
or