How to pass values in pie chart in crystal report
i have tried in pie chart to pass dataset values, but it showing as same it didn't differ based on values
i have used four dataset namely "DATACOLUMN1","DATACOLUMN2","DATACOLUMN3","DATACOLUMN4",
if i pass datacoloumn1=1; datacoloumn2=2;datacoloumn3=0;datacoloumn4=0; it not showing based on values...
Abhilash Kumar replied
What's being displayed is correct,
The 'Count' of records in each of those columns = 1. So, each pie slice is 25% of the total.
Here's what you need to do:
1) Create a formula for each column and type in the 'value'. E.g; formula for datacolumn 1 would contain just:
Similarly, create separate formulae for each column and assign them a value.
2) Go to the Chart Expert > Remove all the existing fields from the 'Show Values Section'
3) Replace them with the formulae you create in Step 1 and make sure that the option 'Don't summarize' is checked for each of those summaries.