Wednesday, October 22, 2014
SQL Reports Extension
compat2.5compat3x
 

Do you want to execute/create SQL queries and make the results visible in your Joomla? hehe... So easy that you don't believe it.

Write the query and the extension does the rest! You'll get a nice report with an Excel export button too.
There are some suggestions:

  • List of users
  • Last users comments in your web
  • Make visible information about your own tables
  • Get administrative reports to your clients about data
  • ... anything you want!
Our philosophy is clear... Responsive, simple, useful and good looking in all our extensions.

Look demo and you decide.

See our live demosScreenshots

 
 

Features

Responsive design.

Manage your own SQL queries and make the results visible in seconds.

No hard configuration that makes you crazy, just create queries and view a very nice and useful reports.

You can hide/show title, Excel export button, pagination, sort, etc.

Multiple reports in the same page with no conflict at all (others do!)

Special tags available to use inside queries to allow queries like ...
SELECT * FROM #__users WHERE id={logged_user_id}

component Component in back-end to create reports
module Module to view them in front-end

Requirements

SQL Reports work properly under the following requirements:

  • Joomla 1.6, 1.7, 2.5, 3.x
  • PHP 5.3+  (No more php 5.2 support - move on to php 5.3)
  • MySQL 5+
  • Do not have extension files or Joomla! core files which have been altered in any way

Important: Only provide support for setups that meet these requirements

Any doubt?

Yes. Sorry I need more info.
Feel free to contact us
Visit the SQL Reports extension forum

No. I think the extension is easy and useful for me.
Subscribe me to this extension and let me download it for 6 months period.

Buy 20€

 

Live demo 1

Report with title, headers, Excel export button and pagination. Try to sort columns!
That's what you get with just write the SQL 'SELECT * FROM population'.

World population ranking

RANK CONTINENT POPULATION
1 Southern Asia 1,749,046,000
2 Eastern Asia 1,620,807,000
3 Europe 742,452,000
4 South-Eastern Asia 618,793,000
5 South America 406,740,000
6 Eastern Africa 373,202,000
7 Northern America 355,361,000
8 Western Africa 331,255,000
9 Western Asia 245,707,000
10 Northern Africa 210,002,000
11 Central America 167,387,000
12 Middle Africa 135,750,000
13 Central Asia 64,370,000
14 Southern Africa 60,425,000
15 Caribbean 42,517,000
16 Oceania 38,304,000

Live demo 2

Report with sortable header and without title, pagination neither Excel export button. You can hide all if you want!.
Just write SQL 'SELECT * FROM user_comments ORDER BY Date ASC'
ID NAME SUBJECT COMMENT DATEPOST
2 o_trebon Thanks a lot Easy to install, works fine, no problem with anything... Good job! 1 hour ago
5 kdagnall Really good Simple to install and it works! Thank you! 1 week
3 imdw Super simple and it works straight away Excellent thanks for this extension. I just needed like this. Essential. Quick install and configuration. Thank you very much!! 2 hours ago
1 camilocero Perfect! I was looking for something simple and flexible, I found with this extension, recommended! 5 mins ago
4 SKrillex Just what I was looking for I made a profile just to make this review! The extension was exactly what I was looking for. The download was easy and after following some simple instructions I had it working on my site. Thank you! yesterday
 

Screenshots Frontend
SQL Reports examples in J25 web SQL Reports examples in J3 web Responsive view in small screens

Screenshots Backend
Report list in backend component Create new/modify an SQL Report Preview of the SQL Report Easy module cofiguration (params)
 

Open Source License. SQL Reports extension is an Open Source Joomla! extension. It is in compliance with the GNU/GPL license: GNU General Public License, version 2. Joomla! is also Open Source.