Introduction

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

  • 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).
  • Selection of PDF generation engine: either server-independent 'dompdf' or more powerful 'wkhtmltopdf' engine can be used. 'wkhtmltopdf' engine requires wkhtmltopdf library to be installed on your server.
  • to be continued...

Wish I'd found it sooner



Posted on 07 August 2021
Functionality
I dove in at the deep end. Did not find this component lacking to create tabulated data reports
Ease of use
If you have a little SQL & Database management jargon knowledge, you should find this easy enough.
Support
I'm a long time customer of Alterbrains. Support has always been top notch.

Documentation
The PDF that comes with the download covers the main points well. I only referenced to set up filters.
Value for money
You get what you pay for they say. I think the value the excellent.
I used this to: To prepare reports of financial membership entities and their delegates stored in our Joomla CMS DB. I'm sure in the future I'll find other uses for it
Functionality
This extension is only limited by one's SQL skills - it can create incredible outputs, and don't think just reports - you can build apps.
Ease of use
The more powerful an extension is, the more time it takes to learn. Same here, but you'll be rewarded greatly for putting in some learning.
Support
I submitted 2 tickets, and always got a speedy reply; the team patiently replied to all of my "oh wait, how about this" requests - thanks!
Documentation
It's decently thorough, though I'd suggest some beefing up (it's just such a powerful extension, it's hard to fit it all into one doc).
Value for money
Incredible! This extension packs a punch - there is so much you can do with it, I feel it's one of the most valuable extensions in the JED.
I used this to: Where other components let us down, this extension steps in - we use it to build various views on the front-end and back-end, including downloadable reports for users who need data without giving them access to admin; also neat list views where another component was lacking.
Functionality
Funktioniert wie erwartet. Vor allem das Scannen der Spalten erleichtert die Arbeit sehr.
Ease of use
Auch wenn das Thema schnell sehr komplex werden kann, die Umsetzung ist super und logisch.
Support
Antwort innerhalb 24h, perfekt. Alle Fragen auch nicht unbedingt bzgl. der Erweiterung beantwortet.
Documentation
Im PDF steht alles inkl. Beispielen was man braucht. Schritt für Schritt wird man an seine Wunschansicht geführt.
Value for money
Absolut fairer Preis. Wird wohl auch kontinuierlich weiterentwickelt.
I used this to: Eigene Berichte mit Daten unterschiedlicher Joomla Tabellen innerhalb weniger Stunden zusammengebaut.
Functionality
The best Joomla extension I've tested and used. Provides dozens of features of the highest utility!
Ease of use
Although it offers a multitude of options, it does it in an organized and logical way, making its handling totally uncomplicated!
Support
I needed help from the support and the response was incredibly fast and effective, solving my difficulty very quickly, on the same day!
Documentation
All available options are well commented on by joomla itself. The instructions for installation and first steps are objective and effective.
Value for money
Considering the production work as well as the availability of support, the value becomes not only fair as even below what could be!
I used this to: I use it on a website of Fluminense Federal University of Brazil, where we develop free social projects and we need to interact with the community served free of charge through the site, providing numerous information from databases fed by our system.
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.
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! 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 term full title and a...
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...
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...
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 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...
Alter Fields Pro
Paid download

Alter Fields Pro

By AlterBrains
Custom Fields
Displays Joomla custom fields in backend item list. For each custom field, you can enable its display in backend item list with some handy settings like CSS classes for table column heading and data cell, field layout (except frontend templates overrides). Support display of custom fields for Joomla articles, users, contacts and categories by default. Its possible to allow table ordering by cus...
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...
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....
Alter Tags
Paid download

Alter Tags

By AlterBrains
Tags & Clouds
Displays item tags in backend lists and adds tags for Joomla! users, articles, categories, contacts, menu items, modules and Regular Labs Advanced Module Manager. You can add tags for Joomla! users: assign tags in backend user edit page and see item tags in backend user list. You can add item tags column in backend articles, categories and contacts lists. You can configure background and foregr...
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...
Alter Optimizer
Paid download

Alter Optimizer

By AlterBrains
Performance
Applies advanced module and content caching to speed-up website performance. Special adjustments help to improve Core Web Vitals score and rank your site higher in Google. The extension provides unique Joomla content and module caching techniques for faster page load. Additionally, it helps to improve page asset loading for faster page load and rendering. Native Joomla component view caching fo...
Alter Fields
Free

Alter Fields

By AlterBrains
Custom Fields
Displays Joomla custom fields in backend item list. For each custom field, you can enable its display in backend item list with some handy settings like CSS classes for table column heading and data cell, field layout (except frontend templates overrides). Supports display of custom fields for Joomla articles, users, contacts and categories by default. Works with 3rd-party Joomla extensions if...
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:
4.1.0
Developer:
AlterBrains
Last updated:
Oct 31 2023
4 months ago
Date added:
Nov 19 2014
License:
GPLv2 or later
Type:
Paid download
Includes:
c p
Compatibility:
J3 J4 J5 J5 (b/c plugin)
Download

Uses Joomla! Update System

Score:


Write a review