Charts

[kab097]

I am trying to implement a chart in a report. I am trying to do a line graph using the "On Change Of" method. However, when I put in my Show values, it automatically makes me calculate using the count method when in fact, I just want to use the value of the field. The Don't Summarize Values check box is disabled. Can someone tell me what I may be doing wrong? Thanks in advance for you help.

 

[kenhamady]

What version of CR?
Are you charting detail values or group values?
What is the data type of the field you are using? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[kab097]

Thank you for responding.

I am using CR 8.5.

I am trying to use the value from my report field (retrieved from a SQL query). I am not doing any type grouping.

The data type for one of the fields is date/time (I want these values to be along the bottom axis of the line graph) and the other fields are strings (I want the hi/lo values along the left axis and the individual values plotted according to the day).

I hope this is enough information.

Thanks again for the help!

 

[kenhamady]

plot the hi-lo value of a string field?
What are some sample values stored in this string field? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[kab097]

Ok the report has 8 fields.

territory 1 total
territory 2 total
territory 3 total
territory 4 total
territory 5 total
territory 6 total
territory grand total
Date

All totals are calculated before they are insterted into the SQL table. CR just uses a simple select query to retrieve information. Luckily, I got this to work well. Here is an example of the data.

date T1 T2 T3 T4 T5 T6 Total
12/12/01 345 445 200 344 670 234 2238
12/13/01 452 123 256 401 556 203 1991
12/14/01 550 330 290 396 531 210 2307

I want the graph to plot each territory point on a per day basis. So it would be a stackable line graph. The days would be along the bottom and the left side would go from 123 (the lowest Territory value) to 670 (the highest value) and each value would be plotted and there would be a line for each territory. For the purposes of the graphs, I would eliminate the Total column. This is strickly to be used to show how territories are doing against each other.

 

[kenhamady]

1) You need to convert each field into numeric equivalent, using the VAL function.

2) Create a chart that is OnChangeOf "for each record", with your fields as the ShowValues fields.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[kab097]

Thanks for your help! I truly appreciate it!