Hello,
I have a database set up with all the information, but I can't get the output the way I need it. I have to get this done today and I'm totally lost.
Everything resides around a customer-Engagement.
There will be a lot of customers, and a number of customers will be on each engagement (contract).
Each customer-engagement has a number of findings/records linked to it. It is the statistics of these records (which I've calculated) that I need to display for each customer-engagement.
Reporting is done by engagement. I also have successfully shown the results from the findings in the current engagement. My issue is finding a way to show all back data attached to the same customer.
Report:
Engagement 123
Customer-A
Findings for this quarter
graph of findings from previous quarters
(Customer-B ommitted because no work performed this quarter)
Customer-C
Findings for this quarter
graph of findings from previous quarters
I can't figure out how to display the data from previous quarters, and also can't get a graph to show. It must be something simple but I've been working on this for a couple days now and can't crack it... I can't upload the DB because it's above the 2MB limit but could email it if given an addres.
Thank you to anyone who can help!
I have a database set up with all the information, but I can't get the output the way I need it. I have to get this done today and I'm totally lost.
Everything resides around a customer-Engagement.
There will be a lot of customers, and a number of customers will be on each engagement (contract).
Each customer-engagement has a number of findings/records linked to it. It is the statistics of these records (which I've calculated) that I need to display for each customer-engagement.
Reporting is done by engagement. I also have successfully shown the results from the findings in the current engagement. My issue is finding a way to show all back data attached to the same customer.
Report:
Engagement 123
Customer-A
Findings for this quarter
graph of findings from previous quarters
(Customer-B ommitted because no work performed this quarter)
Customer-C
Findings for this quarter
graph of findings from previous quarters
I can't figure out how to display the data from previous quarters, and also can't get a graph to show. It must be something simple but I've been working on this for a couple days now and can't crack it... I can't upload the DB because it's above the 2MB limit but could email it if given an addres.
Thank you to anyone who can help!
