Hi,
I am working to convert all Crystal Reports to Telerik Reports. And I see that the Telerik Chart Builder Wizard does not allow to narrow down only selected fields to display on the chart like Crystal Reports (see the attached snapshot). I am new to customize Telerik Report charts and need help to create a pie chart (like the attached image). How can I select only needed fields from a big data source and use aggregate SUM function to display a pie chart with field names shown in the legend.
Thank you for your support.
Khoa
I am working to convert all Crystal Reports to Telerik Reports. And I see that the Telerik Chart Builder Wizard does not allow to narrow down only selected fields to display on the chart like Crystal Reports (see the attached snapshot). I am new to customize Telerik Report charts and need help to create a pie chart (like the attached image). How can I select only needed fields from a big data source and use aggregate SUM function to display a pie chart with field names shown in the legend.
Thank you for your support.
Khoa
3 Answers, 1 is accepted
0
Hi Khoa,
You can either build the series and items programmatically by iterating through the items from the data-source or alter your data-source. For e.g, instead of getting different fields, of data, you want to sum up, you can sum them up in the query and present them as if they were different rows of the same table.
Instead of selecting
Field1, Field2, Field3
... ... ...
... ... ...
... ... ...
select
[Column1]
Sum(Field1)
Sum(Field2)
Sum(Field3)
This way, you will be able to bind the data directly to the Pie series and get the desired result.
For the programmatic approach you can refer to:
All the best,
Elian
the Telerik team
You can either build the series and items programmatically by iterating through the items from the data-source or alter your data-source. For e.g, instead of getting different fields, of data, you want to sum up, you can sum them up in the query and present them as if they were different rows of the same table.
Instead of selecting
Field1, Field2, Field3
... ... ...
... ... ...
... ... ...
select
[Column1]
Sum(Field1)
Sum(Field2)
Sum(Field3)
This way, you will be able to bind the data directly to the Pie series and get the desired result.
For the programmatic approach you can refer to:
All the best,
Elian
the Telerik team
HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!
0
Khoa Ho
Top achievements
Rank 1
Rank 1
answered on 05 Feb 2013, 04:11 PM
Hi Elian,
One thing I found out I can't set DataSource on Properties at the design window because it will get all fields, not selected fields from a big data source. Therefore, I have to bind data from data source to selected fields on code behind. But I still don't know how to build a data view from data source (Telerik.Reporting.SqlDataSource class). I need only one big data source for one call to database, and many data views for many different charts.
Thank you for your support.
Khoa
One thing I found out I can't set DataSource on Properties at the design window because it will get all fields, not selected fields from a big data source. Therefore, I have to bind data from data source to selected fields on code behind. But I still don't know how to build a data view from data source (Telerik.Reporting.SqlDataSource class). I need only one big data source for one call to database, and many data views for many different charts.
Thank you for your support.
Khoa
0
Hello Khan,
The SqlDataSource component is built to support the Data Items used in the report and it is not meant to be executed manually. In your case it is better to select the data programmatically (using SqlDataAdapter for e.g.) and use DataSet / DataTable to keep the data and manipulate it however you need to.
Regards,
Elian
the Telerik team
The SqlDataSource component is built to support the Data Items used in the report and it is not meant to be executed manually. In your case it is better to select the data programmatically (using SqlDataAdapter for e.g.) and use DataSet / DataTable to keep the data and manipulate it however you need to.
Regards,
Elian
the Telerik team
HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!