CrazyEngineers Archive
Old, but evergreen and popular discussions on CrazyEngineers, presented to you in read-only mode.
@Kaustubh Katdare • 23 Mar, 2009
CEans,

I've been searching for one for a long time now but haven't found any. If you are aware of any open source mysql data reporting tool, please let me know.

It would be nice if you suggest something that looks web 2ish 😉 and that generates pretty looking reports.

Anyone?
@shalini_goel14 • 23 Mar, 2009 I don't know much about this but I am not sure whether you looked for ools like Datavision, LogiXML and Altova(free trial for only 30 days) or not? 😕

Anyways few are following links.

Download DataVision 1.2.0 - An Open Source reporting tool similar to Crystal Reports. Reports can be designed using a drag-and-drop GUI. - Softpedia

LogiXML - Free Download

Download Database Reporting Tool: StyleVision

May be of some use depending on the purpose ? 😐
@Kaustubh Katdare • 23 Mar, 2009 @Shalini: Thanks 😀

I did. I was more interested into a simple script that I'd simply upload to the server and connect it to database.
@Anil Jain • 23 Mar, 2009
The_Big_K
CEans,

I've been searching for one for a long time now but haven't found any. If you are aware of any open source mysql data reporting tool, please let me know.

It would be nice if you suggest something that looks web 2ish 😉 and that generates pretty looking reports.

Anyone?
Check if these helps in your requirement:

PHP Report Maker - PHP Dynamic Web Report Generator for MySQL

EspressReport ES - Powerful Java Reporting Platform

-Crazy
@Kaustubh Katdare • 23 Mar, 2009 I specifically need Open Source tools.
@Anil Jain • 24 Mar, 2009 Does this generatedata.com fits in.

-Crazy
@shalini_goel14 • 24 Mar, 2009
The_Big_K
I did. I was more interested into a simple script that I'd simply upload to the server and connect it to database.
Is your problem solved, if yes kindly share the whole problem with solution here. Otherwise I guess you require only a simple script right? Then how come a simple query is not working for you? What is the need of these reporting tools then? 😕

Please make clear.

Thanks
@Kaustubh Katdare • 24 Mar, 2009 No, the problem is not solved yet. I'll explain it in bit more detail -

1. I want something Open Source, PHP based [shouldn't require JAVA to run]
2. Should present user with different search criteria to do combi-searches.
3. Should produce output in simple HTML table.
4. Should provide two levels of access; super-admin & other with restricted access to reports.
5. Should be able to export the data in Excel format.
6. Should have emailing capability built in so that I can send email to users reported after performing the search.

Waiting for your responses!
@jschnip • 28 Dec, 2010 PhpMyAdmin basically has what you are asking for (minus the email capability). It also requires the user to understand a little bit about table structure - but otherwise, its search and export functions should suffice.

phpMyAdmin

I will note that I use the mysql saved query feature for our users who don't understand table structure - so they just select a saved query and export data at will.

The_Big_K
No, the problem is not solved yet. I'll explain it in bit more detail -

1. I want something Open Source, PHP based [shouldn't require JAVA to run]
2. Should present user with different search criteria to do combi-searches.
3. Should produce output in simple HTML table.
4. Should provide two levels of access; super-admin & other with restricted access to reports.
5. Should be able to export the data in Excel format.
6. Should have emailing capability built in so that I can send email to users reported after performing the search.

Waiting for your responses!
@Herberts • 06 Oct, 2011 You need to try FastReport.Net, it will suit your needs
@HKaur • 28 Dec, 2011 To add to the list of reporting tools, ActiveReports Server provides business users with a feature-rich, Web-based, self-service reporting solution, enabling them to easily create sophisticated ad hoc reports. Its browser-based design and secure, scalable storage let IT departments deploy and manage self-service reporting much more effectively than they can with traditional reporting tools.
To know more about the software logon to www.activereportsserver.com
@Kaustubh Katdare • 29 Dec, 2011
HKaur
To add to the list of reporting tools, ActiveReports Server provides business users with a feature-rich, Web-based, self-service reporting solution, enabling them to easily create sophisticated ad hoc reports. Its browser-based design and secure, scalable storage let IT departments deploy and manage self-service reporting much more effectively than they can with traditional reporting tools.
To know more about the software logon to www.activereportsserver.com
I had read about the active reports server. It's not open source, unfortunately.
@PraveenKumar Purushothaman • 29 Dec, 2011
The_Big_K
I had read about the active reports server. It's not open source, unfortunately.
Why not phpMyAdmin?
@davea0511 • 21 Mar, 2012 • 1 like phpMyAdmin is a great database management tool, but not for generating standard reports. What he's looking for is something where you can create a report that his client can simply click a button and it will generate the report using the latest information in the database. Ideally it would also be able to create charts this way as well. At least that's what I'm looking for ... without luck.
@PraveenKumar Purushothaman • 21 Mar, 2012
davea0511
phpMyAdmin is a great database management tool, but not for generating standard reports. What he's looking for is something where you can create a report that his client can simply click a button and it will generate the report using the latest information in the database. Ideally it would also be able to create charts this way as well. At least that's what I'm looking for ... without luck.
Thanks for the clarification buddy! 😀
@KLM • 17 Apr, 2012 Try Reportico. I've just installed it and am trying it out - looks very promising though the setup of the actual report requires a bit of work, and the interface is not flexible enough to include things like LDAP Authentication.

https://www.reportico.org/swsite/site/home/index.php
1.9k views

Related Posts

@Ankita Katdare · Feb 27, 2015

We recently told you about the upcoming projects planned by the Indian Space Research Organisation (ISRO) and how the new chairman plans to execute the various missions. Well, adding another...
3.9k views

@Ankita Katdare · May 21, 2014

A team of engineers from the University of Texas at Austin has developed a new machine called 'The Nanomotor' that is the smallest (1/500th times the size of a grain...
3.4k views

@Mallika Saha · Jun 10, 2014

Hi..I have thought upon a project named remote access monitoring. This project is based upon client server architecture where there are number of clients and one main server. Server can...
16.5k views

@Ankita Katdare · Dec 20, 2010

I just figured out how to format a pen drive on a Mac. I hope this will be of help to all the newbies with Mac. 😀 1. Plug the...
4.2k views

@qwerty123 · May 11, 2012

A program p calls two subprogram p1 and p2.p1 can fails 50% times and p2 can fails 40% times .then p can fail a)50% b)60% c)10% d)70%
2.2k views