akpaga akpaga
Top achievements
Rank 1
Rank 1
akpaga akpaga
asked on 03 May 2012, 05:06 PM
Hi,
I have a Sql query where i have done all my calculations like sum and counts on the fields based on some conditions...all i need now is to display them on telerik control.....But The way i want to repesent them is as in cross tab
x y z
Customer1-Purchase
Customer1-Articles
Customer1-Purchase/Sales
Is there any control that can help me...
I have a Sql query where i have done all my calculations like sum and counts on the fields based on some conditions...all i need now is to display them on telerik control.....But The way i want to repesent them is as in cross tab
x y z
Customer1-Purchase
Customer1-Articles
Customer1-Purchase/Sales
Is there any control that can help me...
1 Answer, 1 is accepted
0
Hello Akpaga,
You can still use the Crosstab - because you have done elsewhere the summing/counting each intersection of a row and column will return only one result - your sum/count. Even if you leave the Detail Values to use the Sum function the results will be correct, but it will be better if you use the First function.
Kind regards,
IvanY
the Telerik team
You can still use the Crosstab - because you have done elsewhere the summing/counting each intersection of a row and column will return only one result - your sum/count. Even if you leave the Detail Values to use the Sum function the results will be correct, but it will be better if you use the First function.
Kind regards,
IvanY
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >