Introduction

Core Enhancements, Data Import & Export, Data Reports, Admin Reports, Tables & Lists

Complete full-featured tool for preview and download of SQL reports in your Joomla site.

  • Favourite
  • Report

AlterReports was designed as a native Joomla reporting extension which covers all needs and aspects of reports for your website. Using SQL queries with rich filters and conditional statements allows you to view and download reports of your database data in most convenient way.

Advanced customization settings allow to adjust visual presentation of your reports.

Access permissions help to control which reports and which report columns to display for certain usergroups, allow/disallow download formats etc.

Features:

View and download reports in both frontend and backend.
Nested categories for reports.
Frontend views of categories (list of categories), category (reports from category) and single report.
Using different databases for loading reports data. Standard Joomla database drivers are supported including MSSQL via 'Microsoft SQL Server Driver for PHP'.
Creating of reports by entering SQL query, editing of query with SQL profile and explain results, easy inserting of tags and database tables into query.
Configurable filters for reports of few types (text field, text area, drop-down lists, checkboxes, radio inputs with either manually entered options or options loaded via SQL query), filter's values can be used in query as via tags.
Conditional statements for query: certain parts of SQL can be executed only if filter's value was entered.
Search in report and download selected rows only.
Ordering of report by column.
Report can be downloaded in configurable CSV, XLS, XLSX, PDF, HTML and XML formats. PDF documents can be customized via custom HTML templates.
Rich customization of report views, HTML, XLS and XLSX formats (borders, colors, backgrounds etc., separate styles for headings, subheadings, data rows and footer row).
Subheadings with ability to span above few heading columns.
Footer row: each column can have custom footer value or auto-calculated values (minimum, maximum, average and sum). XLS reports can have footer values either pre-calculated or have formulas (built-in AVERAGE(), SUM(), MIN(), MAX() or you can use own formula with replaceable tags of column data rows coordinates).
Each report column can have own style applied for report views, HTML, PDF, XLS and XLSX formats.
3-levels of style settings: global settings, individual report settings, column settings: you can easily change styles for all reports.
Count of report views and downloads.
Access levels for categories of reports, reports, available formats and columns.
HTML and PHP pre-processors for columns values: you can wrap a value into HTML code or change it via PHP.
Current Joomla user-related and GET variables tags with conditional elements in query (query can be different for user with different usergroups).
Ability to delete selected report rows in backend and frontend.
Ability to embed reports into articles via special {reportid=x} tag (Joomla content plugin is included).
Ability to group report rows by column.
Ability to email reports via special link (great feature to receive reports scheduled by a cronjob).
Import/Export of reports in XML - helps to transfer your reports between local and live servers.
Custom .ttf fonts support for HTML-based reports including PDF (fonts are embedded into .pdf documents).
to be continued...

Functionality
I've been working with other components, but Alter Reports has the best functionality for my needs.
Ease of use
Easy with basic knowledge of sql and php. Helpful tool-tips on every config.
Support
Perfect and fast!
Documentation
Documentation exist, but could be more detailed. My problems were solved by excellent support and helpful tool tips.
Value for money
Definitely good value.
I used this to: convert complex reports from MySQL to Excel.

Great Extension!



Posted on 09 April 2018
Functionality
I have been programming on mainframes for 30 years. Alter Reports is extremely functional
Ease of use
Requires some knowledge of report design but i have never done it before and figured it out. SQL experience is required.
Support
PERFECT! QUICK! They really want to help!
Documentation
Really good with technical issues addressed.
Value for money
WOW! Where is the "200" rating.
I used this to: Writing a series of reports for the dog rescue indusrty in the united States.
Functionality
One of those great extensions which balances power, flexibility and ease of use. Plenty of options for all circumstances.
Ease of use
There could be a bit of a learning curve and users inevitably need to have MySQL skills but the interface is great
Support
Superb, very responsive and happy to add in new or adjust existing features.
Documentation
Comes with a PDf guide which covers the basics but I think it could do with more extensive explanations of all the features.
Value for money
Great value for money as since it can be easily adapted for use in many different ways and for different reasons.
I used this to: Creating custom reports for client sites which otherwise simply wouldn't be possible and making the data openly available through the admin interface.
Functionality
This product is designed and built to allow for nearly any possible configuration, or you can compensate by creating a custom template
Ease of use
If you're using a standard configuration, it's a breeze to set up. If you need a custom report template, it's a bit more difficult.
Support
Simply exceptional.
Documentation
Much better than average
Value for money
Very Good
I used this to: creating custom analysis report documents on my website
Functionality
List and print images, numeric and text fields from any table. You can include filters in frontend to select the data you want. CSV download
Ease of use
Very easy with elemental knowledge of SQL. Backend full of elements well distributed who allow you to adjust the reports to your needs.
Support
Fantastic. They answered and resolved my questions in hours.
Documentation
A pdf book with some examples of use and configuration, and a lot of information as complete tooltips in each field of the backend.
Value for money
Reasonable
I used this to: Print a lot of reports with Community Builder as data storage manager.

Well done component



Posted on 29 December 2015
Functionality
The developers obviously put a good deal of thought into how the component would be used. Also, it' evident that they listen to their users.
Ease of use
It's pretty intuitive. It was rare that I couldn't get what I wanted running immediately.
Support
Response is very, very quick. It seems like if anyone in the company is awake, you'll get a response that day.
Documentation
I think this can be better but show me the company whose documentation is tight - I have rarely seen this. Should be improved though
Value for money
Most joomla components have great value for the money. I see this as no exception.
I used this to: Used to generate reports for business users. I have 10 reports they can access. The email capability is great and very helpful.

Great solution



Posted on 18 November 2015
Functionality
Just fire up your SQL queries and leave the views to Alter Reports.
Ease of use
As I say, the documentation's a bit limited, but support is good, and the tool makes light work of custom reporting.
Support
Rapid tech support.
Documentation
The documentation is a little short, and it takes some time to play with to figure out the filter functionalitly, or at least it did for me.
Value for money
This saved enormous amounts of money in developer time.
I used this to: Backend custom reporting of Joomla native data, as well as custom component data.
Functionality
In an easy way I can generate the reports having information I would like to see.
Ease of use
Creation and maintenance of reports is very easy. However you will need to have som SQL skills to generate the reports.
Support
Very good support, good answers and until now (5 tickets) all solved in the promised time. 100 points!!
Documentation
This is the only subject I am not very hapy with. Documentation is a bit poor. However compensated by tooltips in backend and a good support
Value for money
Defintely more value for money than expected
I used this to: Generating reports on use of Additive Manufacturing processes in the European Union. (AM-platform.com)
Functionality
It just works! It includes many ways to manipulate and display reports
Ease of use
Initially appears complex, but surprisingly easy to use. The many configuration options include Tips and are intuitive and easily understood
Support
I cannot praise the support team more highly. My 'special' requirement seemed outside the component's intended scope - no problem for them!
Documentation
User needs some SQL query knowledge, the rest is covered by the intuitive layout and 'Tips' for each config option
Value for money
Definitely good value.
I used this to: Building reports for the management of allocation of people to tasks for a major cycling fundraising event, involving about 400 volunteer road safety marshals. AlterReports is a fantastic time-saver.

Excellent product



Posted on 13 August 2015
Functionality
I wanted to create a report from a complex SQL query that included user defined dates and other parameters. Worked great
Ease of use
Its a little complex, however it is very versatile. Would be difficult to make it much simpler and retain all the benefits
Support
Exceptional. Had a problem and with in 12 hrs it was fixed.
Documentation
Limited documentation
Value for money
Excellent
I used this to: Creating complex reports using SQL and user driven parameters.
Functionality
It has everything necessary to display reports.
Ease of use
It is easy to use when you consider the complexity and possibilities.
Support
It is a pity that the score for the support can not exceed 100. The support team has developed some improvement in response to my questions
Documentation
Value for money
I have saved so much time, so I find it cheap
I used this to: show reports on arms trade with country and year selectors
Functionality
I have websites that work with associations. I use Alter Reports to create very custom reports and member directories.
Ease of use
It is great to use and for the most part I can set up. It does have a easy interface for simple queries.
Support
I want to rave about the support!!! I have very custom queries. The support is very, very fast and always meets or exceeds my expectations!!
Documentation
Great
Value for money
100% Don't hesitate
I used this to: Custom reports and Member Directories. If it is in the database you can pull it with this software. PERFECT!!
MightySites
Paid download

MightySites

By AlterBrains
Multiple Sites
MightySites allows you to run multiply sites on same Joomla installation and share database data between different Joomla sites. No hacks of core files are required and no Joomla! core files are patched.* Ability to use content, users (with Community Builder and JomSocial support) from other sites. You can have many Joomla! websites using a single hosting account, with same users and JomSocial...
p8pbb bridge
Paid download

p8pbb bridge

By AlterBrains
Forum Bridges
Full-featured bi-directional integration of phpBB 3 forum with Joomla! CMS. Forum is displayed inside Joomla! template as usual component. No hacks of core files. Community Builder, JomSocial, EasySocial and Joomla profile integration. OSMap and AlphaUserPoints plugins. SEF URLs and enhanced SEO for the forum. Basic forum customization and modification options. Read about all features on our...
Direct Alias
Free

Direct Alias

By AlterBrains
SEF
Allows you to control menu item alias and have short SEF URLs without including aliases of parent menu items. Joomla native routing is not quite robust and you can't control how the SEF URL of menu item is built. You can only define menu item alias - a component of URL. By default aliases of Joomla menu items are relative: aliases of all parent menu items are auto-prepended to SEF URL. So child...
AJAX toggler
Free

AJAX toggler

By AlterBrains
Admin Performance
Revolution in Joomla Administration - AJAX toggler! Speed-up Joomla! administration with AJAX support! The plugin provides AJAX features and backend page isn't reloaded on various actions like publishing/unpublishing, featuring/unfeaturing, sorting tables by columns, pagination links, filtering, ordering, searching the rows etc. and even shows system messages. Works in all modern browsers and w...
Alter Glossary
Paid download

Alter Glossary

By AlterBrains
Glossary
Extremely powerful and full-featured glossary component for Joomla! Features: Absolutely unique advanced performance optimization for highlighting terms in content items: average server database load and memory usage are significantly minimized. Frontend views 'List of Categories', 'List of Terms from Category', 'Single Term' and 'Add a Term'. Frontend edit and creation of terms. Separating of...
Direct Alias Pro
Paid download

Direct Alias Pro

By AlterBrains
SEF
Allows you to control menu item alias and have short SEF URLs without including aliases of parent menu items. Removes menu items aliases from articles URLs leaving only single article alias. Joomla native routing is not quite robust and you can't control how the SEF URL of menu item is built. You can only define menu item alias - a component of URL. By default aliases of Joomla menu items are re...
p8pbb comments
Paid download

p8pbb comments

By AlterBrains
Forum add-ons. Autonomous
Comment on Joomla! articles in phpBB forums. Auto-creating of phpBB topics for each Joomla! article with including/excluding certain sections or categories. Supports phpBB BBCodes and smilies. Completely AJAX-driven system. Works with MyBlog. Features: Auto-creating of phpBB topics from Joomla! articles with preserving of main HTML tags and images. Selecting which sections/categories to use/ski...
Alter Surveys
Paid download

Alter Surveys

By AlterBrains
Surveys
Powerful tool for organizing surveys or polls in your site with advanced statistics results. This extension is a comprehensive but easy-to-use Survey and Polling Tool. Alter Surveys is designed to create surveys or polls or forms, collect data and present advanced statistics results. Features: Frontend views 'List of Surveys Categories', 'List of Surveys from Category', 'Single Survey'. Configu...
Alter Articles
Paid download

Alter Articles

By AlterBrains
Article Elements
Expand functionality of Joomla articles with highly customizable map, gallery, attachments and related articles features. Admin can configure additional data in backend article edit page, each feature can either inherit global settings or use own individual settings per article. Common features: Each feature can be enabled/disabled for certain categories. You can setup the feature position: 'A...
p8pbb bridge light
Paid download

p8pbb bridge light

By AlterBrains
Forum Bridges
No hacks to Joomla! or phpBB3 is required. Only four Joomla library files are auto-updated but the changes are safe and does not affect normal Joomla behavior. Synchronization of login/logout in phpBB to Joomla and vice verse. Synchronization of registration in phpBB to Joomla and vice verse. Synchronization of user delete in phpBB to Joomla and vice verse. Synchronization of user delete/activate...
AJAX Toggler Pro
Paid download

AJAX Toggler Pro

By AlterBrains
Admin Performance
Speed-up Joomla! administration with AJAX support! Change publishing status, order and sort items in a new amazing way! Works in all modern browsers and with most 3rd party extensions. Ajaxified ordering and pagination of items lists. Ajaxified changing of statuses in items lists. Ajaxified sorting of items lists by search filters. Ajaxified search withing items lists. Editing of list item with...
Modulation
Paid download

Modulation

By AlterBrains
Personal Layout
Improve usability of your website - make modules always visible and available for the user. Allow user to drag-and-drop modules and use them by his choice. This extension auto-scrolls modules vertically and they are always visible for the user. The modules become draggable and the positions are preserved for each user. No database tables or queries, everything is smart and robust. Works with 99...
GSearch - Google search
Paid download

GSearch - Google search

By AlterBrains
Site Search
Search different areas of your website using Google custom search engine. You select your menu items - and search is separated for them! Ideal search solution for big websites. Search module can search all menu items content or only by specific menu item....

Alter Reports

Version:
1.2.1
Developer:
AlterBrains
Last updated:
Oct 31 2018
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Includes:
c p
Compatibility:
3
Download

Uses Joomla! Update System

Score:


Write a review