Reportico PHP Report Designer / News: Recent posts

6.0.11 fixes a bug preventing projects being created under PHP 7.1 and below.

• Reinstated Form mode now available from the Page Setup page
• Theme caching control, with new disableThemeCahcingParameter
• More effective starting of Reportico with start.php instead of run.php

• New PDF Report Engine. Reportico now uses PhantomJS to render PDF documents, this means the PDF output looks much, much more like the the report when shown in the browser. Also styling options for page headers, footers, tables and rows are common for PDF and HTML. Even charts look the same in both formats
• Pagination and Page Control. The report criteria screen now provides a Page Setup button where you can set up page orientation and size. Also this option provides a pagination option ( on by default for PDF and HTMLreports ). This more intelligently paginates the output and allows HTML reports to present the output in pages.
• Page Headers and Footers now showable in HTML reports.
• PDF output can now show total number of paages in headers and footers (so you can show page x of y, for example)
• HTML output now shows in the browser below the criteria entry screen. No more pressing the back button to get back to criteria entry, and this makes it much easier to change criteria and rerun reports
• Themes - Customizable Look and Feel. All report and screen out is rendered through themed template files. Just copy the default theme template area under the themes folder to another with a name of your choice, reference this in the run.php file and then change the appropriate template and css files as you wish.
• ReporticoDefaults.php file now deprecated. Project and Global default page headers/footers and styles were set using this method before. Now style customisation should be set by modifying the theme stylesheet. Default headers and footers are set in the project config.php files ( search for output-sections in new project config.php files ).
• Reportico completely re-architected into a composer package and therefore installable as a module in popular CMS and web frameworks like Laravel

New release 4.6 ...

Includes:-

• New Finnish Translations kindly provided by Jorma Hytonen
• New Filter group option to allow multiple filters to be collapsed until user uncollapses
• Ability to save a report from the criteria screen ( without having to go into design )

Version 4.5 includes a lot of new features including :-

• New look and feel of criteria entry screen with new icons kindly donated by icons8.com
• Error and warning messages now appear in nicer modal popup
• New Criteria Help option provides explanatoory tooltips on user criteria
• Ability to make a criteria item mandatory so user is prompted is value not provided
• Abiliity to hide a criteria item for use when a criteria value is provided externally
• New criteria search boxes which are searchable and dynamic based on the select2 library
• Project Creation and configuration now simpler with less options
• New Brazilian Portuguese language pack ( thanks to T Kramer )
• Improved Spanish Translations ( thanks to shawe )
• New tutorials including PDF Invoice generation
• Project menus in design mode will by default present all available reports in main static menu
• PDF and CSV documents now download without opening up a new browser window (thanks to nmcgann and download.js) .. configurable by pdf_delivery_mode in run.php
• Date Range pickers automatically change End Date to Start Date
• If Admin password is set to OPENACCESS admin allows password free access to design mode
• Ability to hide the Go and Reset buttons from the Criteria Entry screen - enabled by default
• Show/hide checkboxes for controlling output of detail, charts, groups etc hidden by default in criteria page - turnon with show_hide_prepare_section_boxes in run.php
• Updated to latest Bootstrap libraries
• Lots of layout changes and bug fixes... read more

This version provides 2 new features:-

1. New PDF report engine produces more attractive PDFs with custom text blocks and styles
2. Custom styling defaults can be applied globally to all reports with the reportico_defaults.php file ( see - http://www.reportico.org/documentation/4.3/doku.php?id=report_default_styles_and_behaviour )

Get it here:-
http://sourceforge.net/projects/reportico/files/reportico-4.2.zip/download... read more

Version 4.2 release is available. This version provides the ability to store your reports in another folder through the projects_folder parameter. There are also various bug fixes.
Get it here:-
http://sourceforge.net/projects/reportico/files/reportico-4.2.zip/download

Also checkout the new quick start area:-
http://127.0.0.1/reportico2/web/index.php/quickstart/

Version 4.1 release is available. It provides quick edit buttons in design mode. Single click buttons to enter report SQL queries, column parameters and more save time in designing and debugging reports.
Get it here:-
http://sourceforge.net/projects/reportico/files/reportico-4.1.zip/download

Screenshot of new editing buttons here:-
http://www.reportico.co.uk/images/reportico41.png

Version 4.1 Beta release is available. It provides quick edit buttons in design mode. Single click buttons to enter report SQL queries, column parameters and more save time in designing and debugging reports.

Get it here:-
http://sourceforge.net/projects/reportico/files/reportico-4.1.Beta.zip/download

Screenshot here:-
http://www.reportico.co.uk/images/reportico41.png

New features :-
Dynamic sortable, searchable, pageable gridsPass sql to reportico engine without having to create report
Support for bootstrap look an feel both in standalone mode and when embedded in bootstrap enabled web pages.
NVD3 charting library
New SQL command criteria option to allow users to type in SQL
Dropdown menu and static menu array passable to reportico engine to create configurable report menus
Configurable turning on and off of UI elements such a report control checkboxes, output buttons etc... read more

New stable release of Reportico available with the following features:-
Button to print HTML report suitable for printing
Form Report with a 2 column page per report row
New button icons for output format selection and report control
Report group sections now in tables separate div instead of one big table
Improved passing of external user parameters using user_parameters array

New beta version of Reportico available with the following features:-

1. Button to print HTML report suitable for printing
2. Form Report with a 2 column page per report row
3. New button icons for output format selection and report control
4. Report group sections now in tables separate div instead of one big table
5. Improved passing of external user parameters using user_parameters array

Major release :-

• Much easier to embed reportico in web pages using access mode code control and defaults
• Access mode allows you to restrict view to a single project, single report or just to view report output ( e.g. with no annoying return button )
• Easier ability to generate report output with control of display of group headers, detail rows and charts
• Allow reportico to be run solely on AJAX without need for full page reloads using reportico_ajax_mode property. Allows reportico to run independently of surrounding content
• Easier to generate report output within web pages
• Easier integration with CMS systems
• Queries can filtered by user by using the external_user property
• User criteria is displayed more correctly on reports
• Refresh Button on Reports through show_refresh_button_property
• Project menu.php can include drop down report option menus by providing dropdownmenu array in project menu.php
• Session namespacing to allow chaing of reports and allow output for multiple reports to appear in a single page

Minor release that fixes several important bugs :-

Make SQL non case sensitive by allowing lower case FROM
Prevent open_basedir issues by ignoring errors around searching invalid search paths
Support Data Time handling in PHP version <= 5.2.17

And adds the following features :-

Allow square brackets in queries for use in match strings
Variable length criteria multiselect box
Allow Image URL images to have a width specified

This release contains an important fix for a criteria handling problem found in version 2.5 .. any reports created in version 2.5 ignore criteria's linked via the Main Query Column parameter in the criteria details tab. Only criterias linked in through the core SQL were handled. Anyone using 2.5 should move up to this version

Version includes the following features:-

Allow wider range of SQL syntax including embedded selects
New graphing engine using pChart 1.3
Fix CSV output not handling special characters or double quotes
Support date handling in PHP verisons < 5.3
Allow template plugins of project dropdown menus

Version includes :-
Multiple language and character set support including UT8
PDF support for Unicode fonts
Style (colours, fonts, border)
Include links in HTML and PDF output
Include images in output
Multiline text wrapping in PDF output
Linking.Importing criteria/assigments in from other reports

This version contains :-

Multiple language and character set support including UT8
PDF support for Unicode fonts
Style (colours, fonts, border)
Include links in HTML and PDF output
Include images in output
Multiline text wrapping in PDF output

Get it now : -
Zip file http://sourceforge.net/projects/reportico/files/reportico-2.4.Beta.zip/download
tgz file http://sourceforge.net/projects/reportico/files/reportico-2.4.Beta.tgz/download

Interim release to fix incorrect setting of default timezone which causes unwanted error messages in some environments

This release adds in support for PHP reporting from Oracle and PostgreSQL, improved font support for charts. Also bug fixes for application framework integration, improved stylesheets for printed HTML output and improvements in drilldown creation.

This release fixes problems when running Reportico under IIS or on Windows. If you previously tried installing Reportico on Windows without success then try the 2.2 release.

You can now get support and information by posting queries on the Reportico support forum available at http://www.reportico.org/swsite/site/forum/

October 15th - Version 2.1 Released This version contains :-

* a date picker for report criteria entry, javascript criteria lookups
* output in XML and JSON which can turn your report suite into a web API
* Bug fixes in PDF generation
* Improved look-and-feel and 2 new style-sheets

Version 2.0 is released

This has an improved look, includes password control for administrator functions and for user access to project reports. Also some bug fixes.

Other enhancements :-

Experimental support for sqlite3, locale handling for dates, Submit buttons named submit dont work, PDF output does not show last column

Includes :-

- CSV format shows group headers as row level items.
- Some ability to show the user report criteria within the report output
- The ability to include Reportico from another directory in order to embed in another application such as the yii framework
- Cosmetic improvements