Hi, i am trying to plot a line graph in crystal report but i am not sure which value should i put in the chart expert. I.e On Change of record, value -> show value.

In my database i have the following columns.

Date,Weight

I would like to plot a graph with the Y axis the weight range, the X axis will be the count of weight.

VB Code:
  1. e.g

  2.  
  3. 4kg          x

  4. 3kg

  5. 2kg

  6. 1kg

  7.        1 2 3 4

  8.          Count

So i know there are 4 counts of 4kg in the database. By the way, if the range of count is wide.how do i make limit it to like 10 counts per page. so if there are 40 counts , it will be 4 pages.

thanks experts!