Bar Chart Issue

[aball65]

I'm having trouble formatting a bar chart report. My query (shown below) returns 4 rows of data. The report correctly displays the data in the bar chart. However, the report generates 4 bar charts. I'm guessing it's doing this since my query returns 4 rows of data. Any suggestions on how to modify the report to display 1 bar chart?

SELECT
Count(RISK.r_id) AS CountOfr_id,
R_PROG.value,
R_PRIORITY.value
FROM RISK,
RMC_STATUS,
R_PROB,
R_PROG,
R_PRIORITY,
R_COST_IMP,
R_SCHED_IMP,
R_PERF_IMP
WHERE
(((RISK.rmcs_id)=[RMC_STATUS].[rmcs_id])
AND ((RMC_STATUS.value) Like '*open*')
AND ((RISK.rpb_id)=[R_PROB].[rpb_id])
AND ((RISK.rpg_id)=[R_PROG].[rpg_id])
AND ((RISK.rci_id)=[R_COST_IMP].[rci_id])
AND ((RISK.rsi_id)=[R_SCHED_IMP].[rsi_id])
AND ((RISK.rpi_id)=[R_PERF_IMP].[rpi_id])
AND (([R_COST_IMP].[value]+[R_SCHED_IMP].[value]+[R_PERF_IMP].[rpi_id])=[R_PRIORITY].[total_impact]) AND ((R_PROB.rpb_id)=[R_PRIORITY].[rpb_id]))
GROUP BY R_PROG.value, R_PRIORITY.value;

 

[boblarson]

Instead of putting the chart in the details section, put it in the header or footer.

 

[aball65]

That did the trick. Thanks a ton!

 

[boblarson]

sure thing