We have a very detailed database which imports data from clients via email and displays these records nicely to a telephone research unit (not cold calls - Market research).
The survey system is all part of the same database and until now, we have built all our reporting systems in access using excel as a helping hand.
This has been working fine till now, but we're getting more and more requests for reporting that we just can't keep up with, and with the amount of clients we have, we're struggling to keep track of all the changes and anomalies to our reporting systems.
This is creating massive problems for us.
We are VERY happy with the data side of things, but we are desperate to find something out there that can create reports on our data without much work for us (we don't want to change table structures and queries if we don't have to).
Also, a nice to have, would be for clients to access their reports themselves, or to perhaps update data in our systems.
Does anyone know of any reporting systems out there suited to a situation like this?
If it helps, our "answers" table, has a row for each answer supplied to each question
SN - Q - Score
123 - 1 - 5
123 - 2 - 10
123 - 3 - 2
123 - 4 - 6
Really hope someone can help.