Charts in a report
- Thread starter Nancy2021
- Start date
- Local time
- Today, 05:52
- Joined
- Feb 28, 2001
- Messages
- 30,315
Yes, but it would be (a) complex and (b) odd-looking since charts usually are defined to show a trend or pattern visually. What is the pattern of a single point?
We want to generate a letter for each student that is chronically absent with a chart showing a comparison of the number of days they are out compared to the average of all students in that grade level.
- Local time
- Today, 11:52
- Joined
- Jul 9, 2003
- Messages
- 17,471
isladogs
MVP / VIP
- Local time
- Today, 11:52
- Joined
- Jan 14, 2017
- Messages
- 18,903
I do have a number of different ways of generating charts and at least one would probably be adaptable for your needs.
In fact, when developing my databases for schools, we generated a lot of data and charts of this kind
However, before suggesting any solutions, it would help to see some example data.
Can you post data that I can use together with any relevant queries used to calculate the average for each group of students.
Make sure the data is anonymised by changing names or by just supplying student IDs
In fact, when developing my databases for schools, we generated a lot of data and charts of this kind
However, before suggesting any solutions, it would help to see some example data.
Can you post data that I can use together with any relevant queries used to calculate the average for each group of students.
Make sure the data is anonymised by changing names or by just supplying student IDs
I changed the names and the student ID numbers so nothing is identifiable. I also left some of the fields blank, just to keep it more generic. I only included a few records to keep it simple. I have the averages for days out, what I am stuck on is creating a graph for each record in the rptStudentAttendanceChronicDecemberNinthGrade report. The graph should compare the average days out to the number each student is out. After we are able to add the graph to each record in the report, our ultimate goal is for each record to be in a letter format that we can send home to parents. I know the formatting on the reports is rough. I figured I would clean that up once I knew for sure which queries and reports I was actually going to use. I have been doing a lot of experimenting...
isladogs
MVP / VIP
- Local time
- Today, 11:52
- Joined
- Jan 14, 2017
- Messages
- 18,903
I've had a quick look but it really isn't clear what you want as output
Do you want e.g. 2 horizontal bars with lengths proportionate to the number of days?
For ideas, have a look at the screenshot examples at
www.isladogs.co.uk
or the Incident Analysis example at:
www.isladogs.co.uk
How do you intend to get the chart output into Word for your letter?
Mail merge? If so, I've never exported a chart to Word
Why not do the letter as an Access report instead
Do you want e.g. 2 horizontal bars with lengths proportionate to the number of days?
For ideas, have a look at the screenshot examples at
School Data Analyser
School Data Analyser is used to manage and analyse student, staff and school data.
www.isladogs.co.uk
Multiple Group & Filter
This article discusses different ways of filtering and grouping data in Access. It includes two example apps showing the use of multiple combo boxes & toggle buttons to filter and group data.
www.isladogs.co.uk
How do you intend to get the chart output into Word for your letter?
Mail merge? If so, I've never exported a chart to Word
Why not do the letter as an Access report instead
