Reporting Problem - Group Footer

[John Baker]

I am stumped on this one and am hoping someone can provide guidance....

I have a report that is based on a crosstab query that summarizes the status of problem management tickets (e.g. open, linked, closed). The report is grouped by PRODUCT_TYPE and for each PRODUCT_TYPE, there are one or more PROBLEM_TYPES. The Detail section of the report works just fine. There is a separate detail line for each PROBLEM_TYPE that summarizes the total number of problem management tickets by status.

What I would like to do is add a Chart in the PRODUCT_TYPE Group Footer that illustrates the breakout of PROBLEM_TYPES for each PRODUCT_TYPE.

Here is the SQL string that is used for the Chart in the Group Footer:

SELECT qry_prod_prob.PROBLEM_TYPE, Sum(qry_prod_prob.CountOfINCIDENT_ID) AS SumOfCountOfINCIDENT_ID
FROM qry_prod_prob
GROUP BY qry_prod_prob.PROBLEM_TYPE;


My problem is that the chart illustrates the summary of al PROBLEM_TYPES for all PRODUCT_TYPES. What I want is to limit the chart to the PROBLEM_TYPES for the PRODUCT_TYPE that is being summarized in the PRODUCT_TYPE Group Footer....

Any help or advice would be welcome.

Thanks!
John