click the slice of pie chart

[yasotha]

Is it possible to navigate to a table containg the project details for the click event on pie chart (Both pie chart and table in same report.)?

That is the pie chart use to display number of process associated with each project.
So when click on one slice (represent a project) it should navigate to a table with project details in the same report.

[Steve]

Hi Ysotha,

The short answer is no, the supported interactivity in Telerik Reporting currently works for the whole report item only, for more information please refer to Adding Interactivity to Reports

Regards,
Steve
the Telerik team

[yasotha]

Hi Steve,

Thanks for your reply.I have another query as well.
Is it possible to pass the datapoint value of pie chart for click event to a parameter?

Regards
Yasotha

[Steve]

Hi Ysotha,

It is not possible to get the value of the pie slice, as the action is performed over the whole chart item and we are not aware in which part of the chart image you have clicked.

Greetings,
Steve
the Telerik team

[yasotha]

Hi Steve,

Thanks, I would like to display the dates against the name of the projects in a gantt chart.
That is X- axis : Date
Y- axis: Project Name.
I tried in teleric reporting but getting an error "Value cannot be null , Parameter name : key"
Could you please let me know any solutions. Does telerik supports date data type to display in a chart?

Thanks
Yasotha

[Steve]

Hello Ysotha,

Check the following blog post that elaborates on your inquiry: Displaying Incremental DateTime Values in the X-Axis of RadChart.

Greetings,
Steve
the Telerik team

[yasotha]

Hi Steve,

Thanks for your reply. It works ok. But i need to display the project start date and end date Vs project name in a gantt chart.
Is it possible to implement this? Do you any sample code to create a gantt chart.

Regards
Yasotha

[Steve]

Hi Ysotha,

The main difference about Gantt charts are that they visualize time based information. With that in mind, the creation of the chart itself is pretty standard i.e. you can use as basis the following help article Creating Chart Programmatically - more complex example where only the part of creating the series item should be replaced with something like this:

ChartSeriesItem item = new ChartSeriesItem() { YValue = 5, YValue2 = 7 };
RadChart1.Series[0].Items.Add(item);

The easiest way to get on the right track is to setup the series and their items through the report designer and then check the code it has generated for the chart in the InitializeComponent() method.

Regards,
Steve
the Telerik team

[yasotha]

Hi Steve,

Is it possible to retrive the data from database and represent in a gantt chart rather than setup the series and their items through the report designer?
 
Thanks and Regards
Yasotha

[Steve]

Hello Ysotha,

Yes, you can use the DataSource property of the chart to bind it to one of the supported Data Source Components. You can review our demo reports using chart where we have used this technique.

All the best,
Steve
the Telerik team

[yasotha]

Hi Steve,

Is it possible to integrate Telerik Reporting into Share Point?


Thanks and Regads
Yasotha

[Peter]

Hi Ysotha,

Yes, you can integrate Telerik Reporting Web report viewer in SharePoint. For more information check out Deploying Web ReportViewer in SharePoint help article.

Additionally you may find useful How to use SharePoint List for Telerik Reporting Datasource blog.

Best wishes,
Peter
the Telerik team

[Vijetha]

Hi,

I want to display the % of a pie chart using chartseries in report viewer for Telerik.Reporting.Chart chartGeneric;

I added this chart dynamically to my report.

Below are the line of code which i have written to diplay % of slices
my datatabe
----------------
name   Amount
Sony     120
Nani    100
Hhhh    132
sdjkh    45
uiiuo    67


 public Report1()
        {
NeedDataSource += new EventHandler(Report_GetDataSource);
        }

 void Report_GetDataSource(object sender, EventArgs e)
        {
              generateChart(resultsTable)
        }

 private void generateChart(DataTable dtResults)
        {
                chartGeneric.IntelligentLabelsEnabled = false;
                ChartSeries serie = new ChartSeries();
                serie.Type = ChartSeriesType.Pie;
                serie.Clear();
                serie.Name = dtResults.Columns[0].ColumnName.Trim() + " - " + dtResults.Columns[1].ColumnName.Trim();
                serie.Appearance.ShowLabelConnectors = true;
                serie.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
                foreach (DataRow dr in dtResults.Rows)
                {
                    ChartSeriesItem item = new ChartSeriesItem();
                    item.YValue = Convert.ToDouble(dr["Total"].ToString());
                    item.Name = (string)dr["Name"].ToString();
                    item.Appearance.Exploded = true;
                    item.Label.TextBlock.Text = (string)dr["Name"].ToString()+"

 - #%

";
                    serie.Items.Add(item);
                }
                chartGeneric.Series.Add(serie);
           }

But this does not work for me .Instead it shows the amount values on the slices.

My requirement is i have to dispaly the name and the total percentages on the slices which is same as given in below url but does not work any thing for me.

http://www.telerik.com/help/reporting/buildingdatatbindlistcomplex.html

[Steve]

Hello Vijetha,

There is already a working example for your inquiry available in the Data Binding Chart to a Generic List of Objects help article. Note that this code is used in the NeedDataSource event of the chart item and not the NeedDataSource of the report.

Kind regards,
Steve
the Telerik team

[Vijetha]

Hi Guy,

Please find the attached file .

When binding data to chart series as in the obove example i have posted.If my data source is having more of rows some of adjacent slices names of the chart are overlapped and also some text is missing for large text.

Please suggest how to over come this problem.

If this is a restriction for the chart.Then what will be the possible workaround.

Version:Reporting Q2 2011

[Steve]

Hi Vijetha,

When you have so many small values right next to each other, it is possible to have their labels overlap. Generally you can influence this behavior by setting the chart AutoLayout property to True. It makes sure that no chart elements overlap whenever possible.
Another thing to try is setting the IntelligentLabelsEnabled property to True, which should try to arrange them in a manner that they do not overlap with each other or with the pie.
Other things to try include increasing the distance between the pie and the labels. This is controlled by the chart1.Series[i].Appearance.LabelAppearance.Distance property.
Another thing that comes to mind is the StartAngle property, but of course this depends on the data and in some angles might still lead to such problems.

Regards,
Steve
the Telerik team