[RESOLVED] Bar graph in crystal reports

[Developer2007]

Hi,

I am wanting to create a bar graph in my report to have Sales Total on the y-axis and Employee Name on the x-axis.

Fields in the report

salesNo(from sales table) - numeric
employeeNo(from employee table) - numeric
employeeName(from employee table) - varchar
salesQuantity(from sales table) - numeric
salesTotal(from sales table) - numeric


The problem.
When I try to create the bar graph using the wizard it will only allow me to select numeric fields in the "group section within the chart expert" and not varchar fields e.g: I can select the employeeNo to be on the x-axis but not employeeName in the chart expert or wizard.

Where have I gone wrong?


I am using vs2008 and the standard crystal reports that installs with the software (I think it is crystal reports basic 2008).



Thanks in advance
Developer