Report And Graphs
I need a following script created/application created:
I need to track some information and represent it as a graphs.
Namely,
I have a medial company and I need to be able to track the infection rate of my patients:
For example, one table would have following fields;
1. Name of the Nurse on the Case
2. Date of incident
3. Name of the infection
You would see:
1. Anna
2. 01/01/2010
3. Influenza
then,
1. Mike
2. 02/03/2010
3. Pneumonia
and so on…….
ok so at the end, you should have a table that have a bunch of data.
The reports that I need from that table can be:
How many occurances of Influenza we had for the month of January, for the year, for two years – so on.
How many occurances of Pneumonia we had for the past month, year…
VERY IMPORTANT: I need to be able to compare the reports to be able to see if one employee worked on multuple cases with different infections so may be the employee is the cause of the infection for the patients.
I will provide more details as we go.
I need both reports and graphical representation.
