Solved

how to make printable reports on MySQL

Posted on 2014-02-03
2
343 Views
Last Modified: 2014-02-17
I and moving from ms/access to a generic environment so I selected MySQL as my future development database. MS/ACESS contains a pretty string report writing (as well as querying) facilities.

Is there any tool at a convenient const that I could use to develop (I am thinking that, for forms, I could use LiveCode that looks pretty cool
0
Comment
Question by:jirdeaid
2 Comments
 
LVL 12

Accepted Solution

by:
Koen Van Wielink earned 500 total points
ID: 39831412
What is the reason that you're moving away from MS Access? If it's because you need a better DB engine to handle larger quantities of data, you could still use your existing Access reports, but connect Access to your MySQL database rather than the Access database. That would save you the hassle of recoding your reports.
If you do need to shift to another tool, and assuming you're looking for a free, open source alternative, there are a number of options available. What I found on google:

- OpenReports
- Pentaho
- JasperReports
- BIRT

I'm sure there are many more out there, but these names come up regularly. Which one is best for you really depends a lot on your requirements. You mention LiveCode, but that seems to be an application development platform, not a reporting tool. So not sure what you're looking for.
0
 

Author Comment

by:jirdeaid
ID: 39832061
I am moving out on MS/ACCESS for just the following reasons:

* Incompatible with Mac Intosh a number of my clients are raising eyebrows because they use Mac, want to keep it that way and really do not want to run a virtual computer and a special OS just for this (Microsoft want to keep the incompatibility - I reckon that they will have a problem)

* does not really support web based multi-user situations - we need to go to Visual Studio for that

* old reports will be kept under the windows framework. My DB/App work mainly consists of prototyping and doing just that with a convenient framework I can fast develop this also on a Mac... which I am going to buy


I'll take a look to what you found to check if I can migrate (for new applications) in a fast manner
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now