Charts in Reports

[PaulA]

Hi, all--

I'd like to start using charts in a report that will show the activities/progress of patients in our program using outcome data.

I would like to generate one report with each page being the outcomes for one patient so all patients reports would be generated as one report.

Is there a way to set this up so the chart would only show the specific patient's outcomes on that's patient's page? I tried a couple of things but seem to get all patients' outcomes on the chart on every page.

I'm new on the charts in reports in Access, although I use charts frequently and at pretty high levels in Excel.

Thanks.

Paul

 

[boblarson]

You would need to use a GROUP BY Patient in the report and you can choose to have a header and/or footer for that group. You would put the chart in either the header or the footer of the group.

 

[PaulA]

Thanks for your response.

I tried that but it didn't seem to work. That was the obvious thought.

I had created the chart in the detail and then moved it to the header. Would it matter if I made created the chart in the header itself?

 

[boblarson]

Thanks for your response.

I tried that but it didn't seem to work. That was the obvious thought.

I had created the chart in the detail and then moved it to the header. Would it matter if I made created the chart in the header itself?

It's the recordsource for the chart which will need to be limited to the current patient record.