Create chart based on formula fields

[mmorala]

I'm new to Crystal reports.
Is it possible to create a chart based on formula fields? I have a database of account names which I then used formulas to count each account name starting with A's, B's, and so on. I want to show the number of accounts that start with A, B, etc. on a bar graph. How can I do this?

Thanks,
Michael

 

[mbarron]

You can do this with a single formula.
Create the formula:
left({your.field},1)

Then create your Chart using your field as both the "On change of" and "Show values"

Mike

 

[lbass]

Instead of trying to use a summary, you could just create a formula {@account}:

left({table.accountname},1)

Then insert a bar chart, and choose {@account} for the "on change of" field, and choose it again as the summary field, with count as the summary operation.

-LB