I would like to create a pie chart in a pivot as mentioned in the following Article:
https://www.telerik.com/blogs/impress-users-with-new-visualizations-in-telerik-reporting-q1-2013
I am on report designer 2016 R3 but however i am not sure how to set this up correctly. I currently have the following output but i would like this to be broken down to by each campaign, meaning we will get a pie chat for each campaign instead of the total.
i have used crosstab table with the pie chat within them.
1 Answer, 1 is accepted
Hello Balen,
Thank you for the provided information.
In order for each pie chart to have unique data for each "campaign", you need to structure your data so the data for each "campaign" is placed in one row with that campaign name/id, because when you create the table, each row has access only to its data. For example, you may have an array of campaign objects and each can have a Data field that has all the data for that campaign. Then you can bind the pie chart to use that Data field for its DataSource and thus the data for the campaigns won't get messed up. You may set the graph's DataSource with a Binding:
Property path | Expression DataSource | = Fields.Data
Please, take a look at the article How to use the ReportItem.DataObject property in expressions for details and other ways for using the parent data item data.
You could probably also achieve similar results by having a grouping based on the "campaign" name/id and then you could try to bind the graph's DataSource to the ReportItem.DataObject but this approach could be tricky. I suggest trying with the first suggestion, if possible.
I have attached a sample report with an example of implementing the first approach. However, note that the R3 2016 version is a little old now and you may not be able to open the report due to that. You will need to upgrade to at least R3 SP1 2017 and then edit the schema of the report to be able to preview it. You could also try to export it into a CS report - How to import reports created with Standalone Report Designer.
If you have any other questions or need further assistance, please let me know.
Thank you for using Telerik Reporting!
Regards,
Dimitar
Progress Telerik