Chart Not Showing Data

[MelF]

I've made a pie chart with the record source being Chart Query. This query runs fine, and is listed fine in the Record Source field in Properties for the chart; however, when I go to Report View - Only the title shows up - No chart, etc. Anyone know what might be happening? Other suggestions have been that the record source in the chart properties is not valid, but I've checked, and it appears to be fine. ????????

 

[MelF]

UPDATE - Still having problems with this!! The query runs fine. Has anyone else experienced problems with their chart data not showing up on the report?

Thanks!!

 

[clem]

Did you use the chart wizard to create your chart?

What exactly does your record source property say?

What is the type of information you are trying to capture in your chart?

 

[MelF]

CLEM - Problem solved. I had a field referenced in my link field properties, when it shouldn't have been. Now; however, I have another problem:

I have a Customers table that contains the fields [NumberofComputersSold] and [CRMName]. So when in datasheet view it looks similar to:
# of Computers CRM Name
1 Mike
5 Shontell
3 Sherry
9 Shontell

Well - I need to know how many total computers Mike sold, how many total Shontell sold, etc.

I know it might sound simple - But how can I separate out how many each of them sold?? I only want to see Sherry's name once with one total, Shontell's name once with one total, etc. I tried putting the Total row in the query, and putting Group By in CRM Name, and Sum in #ofComputers, but it still gives the same info. How do I total all of Sherry's and all of Mike's, etc. ?????????

Thanks!!!!

 

[clem]

In your query, first place CRM Name in the design grid first column, then place # of Computers in the second column.

Now use "group by" for the CRM Name field and select "sum" for the # of Computers Sold field. The resulting query shows Mike with 1, Sherry with 3 and Shontell with 14.

 

[MelF]

CLEM - THANK YOU! THANK YOU! THANK YOU!! I tried that and it worked. One thing I did was take the CustomerID field out of the query. Maybe that was the error! Thanks for your help!!!!

 

[MelF]

O.K. - I think this can be done in a query as well, but I don't know how. It's similar to what I'm trying to do above. I have the customers table that includes the fields OrderDate and #ofComputersSold. I want to find out the #ofComputers sold per month. I put Sum in there and it tells me how many are sold on each date, but I need it split out per month. Is there a Total function I can use in the query to come up the #ofComputers sold for January, February, etc.?

 

[MelF]

HELP! Does anyone have any suggestions???

Thanks!!