SQL Reports Component
Version
1.1 (last update on Sep 16, 2010)
Rating
Compatibility
Votes
Favoured
11
License
GPLv2 or later
Non-Commercial
Type
Views
34220
Date Added
30 June 2008
FEATURES WITH:
* Frontend access;
* Permissions access;
* CVS export;
* PDF report;
15/Sept/2010 - Release which fixes some bugs
I was about to start development of a component such as this when I stumbled onto SQL Reports. Exactly what I needed for the purpose of providing my users with some basic "list" type data queries. Extremely easy to install and use. Great interface design. Well done !
Owner's reply
Thanks a lot. This component is old but with its success it deserves an update :)
This week update it the basic feature that we forgot....delete a report :-)
This component is very helpful and saves me much time. No SQL knowledge needed! The only drawback is that you have to be familiar with your database structure, but that is not much to ask, you should be anyway!! Great for a quick look at any field entries. It exports multiple fields to PDF or spreadsheet. You can save reports that you use over and over again. Fantastic!
I like very much this extension, it's very useful and very simple to install and use, but i need more control for users access like to work in association with frontend user access module for example.
I hope it will could be done in the near future.
Thx very much for the high quality of this extension ;)
I hope it will could be done in the near future.
Thx very much for the high quality of this extension ;)
This is exactly what I've been looking for. It’s so simple and lightweight. I love the frontend access and the fact that users can pull reports themselves now. Thanks!
It looks to me that this ext is at an initial state of a complete development task.
At its current state, it does produce reports both at the back and front end as it promise. It's light and convenient to operate.
I am glad to have a try on it as a Joomla! Non-Commercial component. Many thanks.
At its current state, it does produce reports both at the back and front end as it promise. It's light and convenient to operate.
I am glad to have a try on it as a Joomla! Non-Commercial component. Many thanks.
Owner's reply
Thanks, the idea is not to make something complicated but that works, the final objective is to allow table relations as well. We'll get there :)
I like that you can save the reports for easy access later. I got around the limitation that reports are only available in the back end by a quick and dirty copy into a user version that had a filter on the reports available.
This is a quick and easy way to see your data in the back end. Once you pick the table you wish to display and the fields you want included in the report then you are ready to go! You can filter the results. You can also save reports for easy access later. Limitations include no exporting feature and reports are only available in the back end. Otherwise, it is great!
Excellent extension. Works exactly as I had hoped it would
