Skip to Content
avatar image
Former Member

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

PieChart12.JPG (90.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 29, 2015 at 07:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded