How to display values in charts?

[Privete_member__1338745]

I'm fairly new to Crystal Reports and I'm finding the Charts Expert baffling.

I'm trying to use the value of my column "RESULTS" in a chart (or RESULTS.FINAL as it comes from the server), but I can't seem to get my chart to do anything except "Count."

How do you capture the value in a chart?

I am using Crystal Reports 2016, Support pack 9 patch 4 (version number 14.2.9.4008.)

[raghavendra_hullur · Accepted solution]

Hi,

Seems like the RESULTS.FINAL column for you is having string values from what we can see.

The only options that will be available for string fields at chart level are count and distinct count.

If you are looking for any additional options such as sum, average, nth largest and all, you need to First convert the values to number from string and perform those additional summaries in the chart for RESULTS.FINAL column.

Hope that helps!!

Thanks,

Raghavendra

[Privete_member__1338745 · Accepted solution]

As I said, I'm new. So my next question was, "How do I convert to a number from a string?" However, after a bit of searching, I came across the function "ToNumber." So I created a function: ToNumber(RESULTS.FINAL) and then plugged that into the chart and it works. Thank you!