Chart filter based on header value

[trivanka]

Hi,

I have read few posts in this thread but havent yet succeeded in resolving the issue that I'm facing.



I'm using Sharepoint and Access 2007 in this tool.

Created a table based on sharepoint list which stores project with test execution and Defect status.

Created a report in Access to display project details page wise (meaning one project per page by defining group by on project id).

In the detail section of the report, I have 2 charts (test execution and defect status) and I want these chart to display based on project id in the header. So on each page I'll have a different project id and chart will display based on numbers for that project.

In the RowSource property of the chart, I defined a where clause to get the value of the project id. It works fine for first project but same chart is displayed for second project.

How do I tackle this issue? Do I need to write some VBA code?

TIA
SFL

[trivanka]

I have attached a sample db where report name is defect_status

If someone can help me with this, that would be great.

[trivanka]

Anyone out their who can guide me?

[trivanka]

So no one over here has gone through this issue before?
If anyone can atleast give me a similar thread link which I'm unable to find, it will be very much helpful.