Creating Chart using field values from the report

[N_NAGESH]

I have created a report using a query. Further to this, I have added some fields from the query into the report which calculates the sum of records and the count of records.

My problem here is, using the chart wizard, I am only able to select the fields existing in a 'Table' or a 'Query'.

Can anywone help me to create a Bar chart / Pie chart using the fields in the report?

 

[boblarson]

Is there a reason why you can't do the calculations in the report's underlying query? If you do them there, they would be available to the chart. If you don't, then I don't see how they could be available to a chart on the same report because the calculations wouldn't be happening at the right time in order to pass the values to the chart even if it could reference the report text boxes.

 

[N_NAGESH]

Creating chart using fields in 'Reports'

Hi Boblarson,

I have already done the calcualation in the 'report' underlying the query.

For example;
In the database which I am working on, I have a query to get a list of 'Drawings' executed by a particular team. I have another column in the query with regards to the 'Number of errors in each drawing'.

Now, after I genrate a report out of this query, I have added two 'text boxes' in the report which calculates the 'count of drawings' and the 'Total number of errors'.

I want to generate a 'pie chart' using these two (text boxes) values in the report. Here when I use the Chart wizard, I am only prompted to select the fields from a 'table' or a 'query' . This is the actual problem.

I hope you have understood about my problem in Access reports.

I thank you for your reply.