Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to pass values in pie chart in crystal report

Hi All

   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",

for ex

if i pass datacoloumn1=1; datacoloumn2=2;datacoloumn3=0;datacoloumn4=0; it not showing based on values...

Image

Former Member
replied

Hi Prasanna,

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:

1

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.

-Abhilash

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question