I'd like to ask you for your opinion on the most cost effective and least time consuming solution for business reporting.
I'm a financial controller for a smaller (90 employee) business to business sales organization operating in 2 states. We use an industry specific Enterprise MySQL database based software. Although the workflow as setup in the system is very much customized to our needs, the business intelligence and reporting side of the solution is significantly lacking (we'd like to create our own custom Income statement, Balance sheet, job costing, and host of other reports). Having the developer of the software customize the reporting needs for us is very costly, time consuming, and frustrating, so we made the decision to design and deploy our own reports in house.
We don't have any developers on the staff. We have an IT with limited to no programming experience. From our research we figured that we could either use Access 2013 to connect to our database and create the needed reports, which we'd love to make available to the management via web app reports (don't have SharePoint or just post them to our LAN and provide them with Access 2013 licenses) OR use Crystal reports to create and then deploy the reports (we'd need Crystal Server to deploy to users for self service web access). We would love the web access for our exec team is on the go a lot.
We have some Access experience, none of which is in developing custom apps. We have no Crystal reports experience. However, we have been able to find a TeachUComp.com course lessons on both Crystal and Access.
What do you think would make most sense for our situation? If we have totally missed the mark and there are other, more fitting solutions, what would those be?
Thank you so much for your comments and suggestions!