Tags

New version has new features and issues fixed:

• Added current Joomla user-related tags: {user->id}, {user->name}, {user->username}, {user->email}, {user->registerDate}, {user->lastvisitDate}.
• Added ability to delete selected report rows in backend and frontend using Primary Key and Primary Table settings.
• Improved filter name entered by user.
• Fixed issue with loading data from 3rd-party database.

We added content plugin: now you can embed reports into articles via special {reportid=x} tag.

More user interface improvements:

• Feature: ability to browse and insert table columns into query.
• Feature: ability to browse and insert user tags into query.
• Feature: drag-and-drop columns ordering.
• Change: user tags should be escaped in the query.

New features:

• Allowed ordering by multiple fields.
• Allowed tags in HTML processing of column value.
• /* IF NOT tag */ conditional element.
• /* IF tag = ’test value’ */ and /* IF tag != ’test value’ */ conditional elements.
• Show 'No Reports' Message setting for category layout.

• Feature: {user->levels} user-related query tag with comma-separated user authorized levels.
• Fix: disappearing titles with tooltips in frontend.
• Fix: table ordering in frontend.
• Feature: new settings 'Show Limit Box', 'Show Ordering Options' and 'Print Layout'  for Backend View in component settings and report settings.
• Feature: {VALUE} tag for 'Footer Label' field (ex 'Footer Custom Value').  It allows to display a text with calculations like 'Total: 20' by using label text 'Total: {VALUE}'.
• Feature: 'Default Value SQL' setting for Calendar filters - now you can load default value from database.
• Feature: ability to group report rows by column.

Fix: issue with XLS download and remote database usage in frontend.

• Feature: calculate footer formulas using initial data unaffected by PHP processors.
• Feature: new column setting 'Footer PHP Processor' to parse footer value before output.
• Feature: filter tags and conditional elements in options SQL query for drop-down filter.
• Feature: GET variables tags like {get->user_id}.
• Feature: PHPExcel library updated to 1.8.0.

• Feature: calculate footer formulas using initial data unaffected by PHP processors.
• Feature: new column setting 'Footer PHP Processor' to parse footer value before output.
• Feature: filter tags and conditional elements in options SQL query for drop-down filter.
• Feature: GET variables tags like {get->user_id}.
• Feature: PHPExcel library updated to 1.8.0.

• Feature: 'Vertical' report layout - allows to display headings and report data vertically.
• Fix: once checked checkbox filter always had last option checked.
• Fix: issue with filters not applied.

Finally we added PDF reports download. You can customize PDF like other formats: set document orientation and size, setup fonts properties, colors and backgrounds for table header, body and footer.

The most exciting feature is that you can create own custom HTML templates and they will be auto-converted into PDF documents, so you can embed logo images and other data.

The next major feature we will add is report caching: report generation can take time, but sometimes we don't need to generate reports using live data and cached file can be loaded immediately, cached report can be re-created after certain period of time, so it will be not outdated.

Tons of new features including auto-emailing reports by cronjob link:

• Feature: ability to check multiple filters via /* IF filter1,filter2 */ conditional statement, just use comma-separated filter tags.
• Fix: Document Format missed in PDF settings of individual report.
• Feature: 'Group Column Sum' setting allows to display sum of values of a column in the most right column of grouped column row.
• Feature: new setting 'Custom Size' allows to set custom PDF page size.
• Feature: new PDF setting 'Initial View Style' allows to control the fit of page on initial view.
• Feature: new setting 'Limit Box Options' allows to customize limit box options.
• Feature: ability to use filter tags in column subheading.
• Feature/changes: 'Force Download' setting removed, new setting 'Download Mode' allows to select report download mode: download, or open in same window, or open in new window.

The most useful feature of this new release is an option to use wkhtmltopdf engine to generate PDFs. This engine allows to generate really large PDFs and consumes less server resources (time and memory) than previously used default 'dompdf' engine.

• Feature: use {REPORT} tag in report email body to embed a report table.
• Feature: new advanced report setting 'Frontend Connection Failed Article' allows to display specific article if a connection to report's database can't be established.
• Feature: new setting  'Email Min Rows' in report's Email settings allows to send email only on minimum number of rows in a report.
• Fix: SQL query editor auto-height limited to 40 rows.
• Feature: new report setting 'Advanced -> Query PHP Processor' allows to execute custom PHP code on report SQL query.
• Feature: new dropdown/radio/checkbox filter value setting 'Values SQL Query' to load default value(s) dynamically.
• Feature: use {user->field_XXX} tag for custom user field XXX.
• Change: 'Print Layout' setting renamed to 'Print Orientation'
• Feature: added 'Print Layout' setting to select custom print MVC layouts.

• Feature: new advanced report setting 'Delete Query' helps to have custom control over the rows delete operation.
• Fix: print layout not applied in frontend.
• Feature: default value for Calendar filter accepts PHP's DateTime contructor values like '-30 day'.
• Feature: custom date format for Calendar filter.
• Fix: 'select all' link doesn't highlight all options in multiple-select dropdown filter.
• Fix:  issue with /* IF filter_tag = 'value' */ condition statement.