Version History

Listed below are the new functions and fixes deployed in each release of QLR Manager. If you are not already running the latest version, we urge you to upgrade and take advantage of the latest features, fixes and performance improvements. Click here for more information about upgrading. License files are generic for all releases within a version and backward compatible. For example, a version 9 license will work with all versions and releases of QLR Manager starting with 9, such as 9.1.0.

Date Version Description
October 10, 2017 10.1.1
Fixes:
When multiple steps in a Macro contained FusionCharts and were sent as emails, only the last chart was included.
The Report column sorting feature would occasionally omit rows after sorting.
When a Query or Macro containing an error was launched from a Menu Widget, the output page did not contain a "Return to menu" link.
September 25, 2017 10.1.0
New Function:
A copy function has been added to tabular forms allowing the User the ability to copy changes made in each table column. The function works by copying the updated data to all the rows that follow the row that was changed.
Fixes:
Hidden elements in tabular forms were generating column titles when they should not have been.
Widgets that were associated to database engines other than the database engine where QLR Manager resides were not rendering.
September 7, 2017 10.0.1
New Function:
In My Menu, objects not saved in a folder are now placed in a folder of (none) when other items of that same object type, such as queries, are saved in different folders.
Fixes:
Chart data filtering, when the data plot orientation was by row, was not working.
When parent / child controls were defined in a Form's search panel, QLR Manager would fail.
The pop up calendar was not placing itself correctly on the screen when used in a Form that was wider than the screen.
When editing User ID's the proper adjustment for MS SQL vs. SQL Server was not being made.
August 25, 2017 10.0.0
New Function:
All QLR Manager output is now HTML5 compliant.
Redesigned User Interface with smoother operation.
Fully compatible with PHP 7.
Most styles converted to external classes for easier customization.
Report output can now be filtered. When the filtering icon appears in the upper right corner of the report output panel, it can be clicked on to launch a report data filtering interface.
Report data can be saved as "Report Cubes". Once saved the data can be retrived from the Query Panel.
When tracking query and macro usage, QLR Manager can now be configured to delete old entries after a set number of days.
Existing queries can be included in the current query text using the format of qlr_include(query owner.query name).
Fixes:
Numerous bug fixes implemented.
June 16, 2016 9.6.0
New Function:
Numerous new formatting options to enhance a chart's appearance have been added.
Tiny MCE Editor is now used to format custom Layouts.
Data importing improved to handle multi-byte UTF-8 data types.
A global "no result" message can be defined for SELECT queries that do not return any rows of data.
Fixes:
Formatting problems with multi-section forms has been fixed.
The error message displayed when the number of allowable concurrent users is exceeded has been fixed.
April 1, 2016 9.5.0
New Function:
Output from multiple Macro steps can be combined to created a single PDF document.
ODBC data retrieval speed greatly improved.
Macro E-mail recipients and distribution lists can now be managed via an e-mail management interface.
Fixes:
Issues with running Macros via an external CLI interface addressed.
Localhost domain licensing now requires the User to provide a machine name.
December 11, 2015 9.4.1
New Function:
The Data Importer can now process delete transactions.
Several new date / time formats have been added to the Layout panel.
Several new replacement variables have been added that can be used in a report layout: qlr_query_owner, qlr_query_name, qlr_layout_owner and qlr_layout_name.
Query variable references used in Macro steps are now examined to determine if they are found in the query associated to that macro step. Invalid entries are flagged as an error.
Fixes:
Page spacing when the final break text spilled over into a new page has been fixed.
Improve the display of non-standard ASCII characters in Excel exports.
November 19, 2015 9.4.0
New Function:
A digital clock has been added as an optional feature for the Calendar input controls. This allows for a complete date time, such as 2015-11-18 14:23:52 to be specified as an input control value.
A digital clock has been added to the Time Input Control type.
User accounts can now be created at the database engine + server level. Previously, User accounts could only be created at the database engine level.
The color of both vertical and horizontal grid lines used in charts can now be specified.
The SQL used to create a view is now displayed when the "Table info" request is executed on the Query Panel. This is the case when the table selected is really a view and not a table.
The default plot range colors have been changed to match the default colors used by FusionCharts.
Fixes:
Macro execution of queries that were pointing to different database servers within the same database engine were not executing properly.
Addressed issues when non-standard ASCII characters were not displaying properly in Excel exports.
Vertical grid lines in single series plots for Fusion Charts were not appearing.
October 14, 2015 9.3.0
New Function:
Sliders have been added for use as Input Controls. Both numeric and date sliders can be defined to select single data points or ranges.
The Data Importer now automatically refreshes the session between the browser and the server, allowing large data imports to complete without any user intervention.
Fixes:
The leading zeros for text data that happened to be all numeric and being exported to Excel spreadsheets were not being preserved.
The sorting of reports with cached data was not working correctly when switching between table and non-table layouts.
The product upgrade routine for DB2 installations was not working properly.
The color selector used throughout the QLR panels was not displaying the correct current color when launched.
June 4, 2015 9.2.3
New Function:
Custom Cascading Style Sheet (CSS) data can be added to enhance Report Link text or button links.
The positioning of where a Report Link pop up window opens can now be controlled.
The sorting controls can be removed from specific report columns by adding the text <no sort> to the report column title text.
Fixes:
The field size for many of the Layout and other object's text elements has been increased from varchar(4000) to varchar(max).
Extraneous information has been removed when the -- no_result message is displayed for a report that does not contain any data.
April 12, 2015 9.2.2
New Function:
Report links have been added to FusionChart Bar, Donut and Pie charts. This allows the User to click on a chart element to launch a report link.
Fixes:
Addressed problem with FusionChart export where the line on a single line chart would disappear.
Fixed a problem with table referencing in the query Wizard when the first table was removed from the table list.
March 21, 2015 9.2.1
New Function:
Data importer now uses the source file name as the default table name when creating a new table.
Fixes:
Users were unable to delete Input Controls.
Query based valid value lists for Input Controls being used in a Form were sometimes not populating with data.
Mod security strings were not being handled properly in Forms.
February 27, 2015 9.2.0
New Function:
Native SQLite3 support added.
Support for a single character ModSecurity string added.
Support for FusionCharts version 3.4 added.
Implemented better support for FusionWidgets entered into the Custom Layout section of the Layout panel.
Fixes:
Problems with Custom output for Macros addressed.
Under certain conditions the "@" symbol in Macro e-mail addresses was being removed.
The Data Importer was incorrectly evaluating some data as a "date" field type for new table loads.
October 31, 2014 9.1.1
New Function:
Ability to create multiple custom layout widgets in the same report object code added.
Some minor performance enhancements were added to display reports quicker.
An existing database connection can be reused when multiple report objects are referenced in the same code. This results in a much faster display of the output.
Fixes:
Fixed a problem where Evaluated Formaluas in the Report Columns section of a Layout were disappearing when column grouping headers were being defined.
Fixed a problem where grouped columns were not behaving correctly when Layout columns were being Auto Arranged.
When a Form is edited QLR Manager will now check to see if a unique index has been defined for a table that previously did not have a unique index.
Improved the handling of non standard ASCII characters for data export options.
August 11, 2014 9.1.0
New Function:
"Row Hover" coloring has been added. This means that a report data row is highlighted when the cursor is placed on that row.
Column grouping headers and coloring can be applied to contiguous columns in a report.
The User can control if line markers are shown on lines when defining a bar + line combination chart.
Chart filtering now includes the ability to plot data for specific Label values.
Fixes:
The "First" and "Skip halfway backwards" buttons were not active in Table Forms.
Fixed Excel Binary file output containing non standard ASCII characters.
Case sensitivity now honored for fusion widgets defined in custom layout text.
Fusion chart support fixed for report object PDF file creation.
May 2, 2014 9.0.4
New Function:
The ability to control which Report Tools and Output Tools options presented to the end User is now available.
Fixes:
Fixed "% of total" and "% of break" calculations when used in Table Layouts.
April 8, 2014 9.0.3
New Function:
The "% of break" Report Columns action has been expanded to work at multiple break levels.
The "Time" Input Control types have been improved to now include regular expression validation to ensure that what was entered by the User is in the correct format.
The specific Report Tools and Output Tools options that are displayed to the User can be controlled with an entry into the qlr_info table.
A new Input Control type of a searchable select list has been added.
Fixes:
Long text fields were being truncated at 5000 characters when the "Word wrap" Report Column format was being used.
The "% of break" Report Column action was not calculating correctly.
The "% of total" was not calculating correctly when data in text fields began with a number.
The number of unique links being created and stored to support Linked Report has been greatly reduced.
The "Create entry" option in a Form is no longer displayed when the prior form action was to create a new entry using the "Create entry" option.
February 25, 2014 9.0.2
New Function:
Help for Plot Filtering added to the documentation.
The Fusion Chart "Save chart file" added as a field that is saved as a default setting.
Fixes:
The "Folder" field has now been changed to allow null values. This caused problems in Oracle database engines as Oracle treats empty strings as nulls.
Under certain conditions, customized Menu item selection images were not being displayed properly.
February 17, 2014 9.0.1
Fixes:
Forms were not behaving correctly after returning from the message panel when records with duplicate key values were attempting to be added to a table.
The "Average" Layout Action was not working properly when both Group and Break data was specified in a report.
Layout Evaluated formulas that contained HTML formatting for numeric fields was not working properly. When HTML formatting was being added to the output, the resulting value was being treated as zero.
When saving Layout values as the default settings, the title text was being saved as well. The title text is no longer being saved as a default value.
January 21, 2014 9.0.0
New Function:
Data sources can be accessed via ODBC. This includes Firebird and SQLite databases, Excel spreadsheets, MS Access, and other types of ODBC sources.
ODBC and other types of connection strings can now be managed in a table called qlr_host. QLR Manager automatically creates a Form to add and edit this data.
QLR Objects, such as Queries, Layouts, etc. can now be organized into Folders.
More control has been provided to change the appearance of the QLR Manager panels by editing the style sheets found in qlr_manager/styles durectory.
Additional charting attributes added. The User can now control the font and color of the Title, X values, Y values and the Legend. Background gradient coloring has also been added for the chart margin and the plot area. Specific chart sizes can now be defined.
Expanding and collapsing report sections can be defined for Break 1 level of report data.
Report data can be sorted by clicking on sorting icons found in the column headers. This is an optional feature that is set in the Title & Footer section of the Layout panel.
The color of specific report columns can be defined. The coloring can also be set based on the data meeting User defined conditions.
Images of FusionCharts can now be created on the server and included in PDF output and sent in e-mails. This feature requires a free application called fcimg be installed within the QLR Manager directory structure.
In addition to the many FusionChart types supported by QLR Manager, FusionWidgets can now be created.
When an "Image" format is specified in a Layout and only a width value is provided, QLR Manager will attempt to maintain the proper height to width ratio for individual images in a data column.
Bar code formats 25, 39, 128 and codabar have been added. The User can control the bar code height, text size for data displayed below the bar code, the color of the bar code, the background color of the bar code, the color of the text, and whether the bar code is displayed vertically or horizontally.
Layouts can now be dynamically assigned by including the -- use_layout option in the query text.
Macros and Menus can now reference objects from multiple database engines. For example, if QLR Manager is set up in an environment where it accesses both MySQL and Oracle databases, a Menu can be created to run reports from either of these environments.
The data importer can now browse for files located on the server to be imported into a database.
A column action of "List" has been added to Report Layouts. The List function, which works at the Group level of data, will build up a sorted listing of all unique values for that grouping.
July 5, 2013 8.1.1
New Function:
Users accessing QLR Widgets or Report Objects are no longer considered concurrent users and are not counted as a User Seat. Only users logging in through the Connect panel or Connect panel bypass are counted as concurrent users and occupy a licensed seat.
April 12, 2013 8.1.0
New Function:
The source file row number is now displayed when the Data Loader suspends processing due to time limits or a large number of errors.
The User can now set an error threshold count to terminate processing in the Data Importer.
The User can now set a batch size limit for Data Import. The loading process will pause when this limit is reached. This can be very helpful in PHP environments with lower max_execution_time settings.
The login fields that are displayed on the Connect panel can be specified.
Option groups for single select list input controls are automatically created when a third data element is present, and no parent control is specified.
The row size of Table Forms can now be specified to be any number between 10 and 20, whereas before the values were 10, 15 or 20.
A "Move" input control was added which allows the User to select values by moving them from the left list to the right list. The order of the chosen values can be altered by moving them up and down in the list. This is useful in applications where the order of the selected values is meaningful.
A "Combination" input control was introduced which provides both a select list and a text input field. Existing entries can be selected from the list, or new entries can be entered into the text box.
The Report Tools "Save Data to a Table" SQL commands can now be saved to a file to port data elsewhere. This capability can also be accessed in a Macro allowing the User to e-mail the file of the SQL commands.
Input Control default values can now be dynamically created using an evaluated formula. For example, eval(substr(date('Y-m-d',strtotime('today')),5,2)) will calculate the current two digit value of the current month.
Fixes:
Parent / Child input controls were not working properly when the Parent data element contained a comma.
Parent / Child lists that contained an empty value were causing a Javascript error in IE8.
March 1, 2013 8.0.0
New Function:
IBM DB2 database support added to QLR Manager.
"% of break" added as a Report Column Action. This allows for calculating the percentage for each item within a Break so that the total percent at the break is 100%.
"qlr_userschema" query variable added. This allows for the user session query to reference the current schema value. For example, a query such as SET CURRENT SCHEMA = '[qlr_userschema]'; can be added to the user session query.
Layout Actions of 22 and 59 for formatting time to the hour and to the minute have been added. This is useful when grouping time based data together at the minute or hourly intervals.
Files being exported using Report Tools can now be assigned a file name.
Fixes:
There was a Javascript error when using the Object sorting controls with IE8.
The password validation during the install process now accepts all special characters.
Pagination was not working correctly for print paging when a Custom Layout was used for something such as mailing labels.
October 1, 2012 7.3.2
Fixes:
External Macro execution (using runmacro.php) was not creating charts.
Report embedded in Custom Layouts had a PDF page break tag present that would impact PDF output creation.
The Connect panel now properly aligns the connection options when the optional connect panel message has content which fills more than the visible screen.
August 28, 2012 7.3.1
New Function:
Added SQL Server support for newer versions of PHP, which require the use of the php_sqlsrv database functions that are now provided by Microsoft.
The database engine for which a Report Object produces output can be specified. Up until this point, a Report Object could only be created based on the database engine where QLR Manager was installed.
Fixes:
Columns that contain numeric data that have been manipulated with evaluated formulas and contain html tagging, can now be used to create charts.
Report Objects were not working in an environment that did not support global variables.
Wizards were only able to handle up to 10 custom columns in a query. The number of custom columns is now unlimited.
When resetting a Layout, the number of columns in the Layout will now match the number of columns selected in the query.
July 9, 2012 7.3.0
New Function:
PDF output speed and quality has been greatly improved. PDF generation now requires that multi-bytes string (mbstring) support be activated in PHP.
PDF file creation has been added as an output type for Macros.
The level (row, group, break and final) at which evaluated formulas are executed can now be controlled by the User.
Two new date formats DT21 (May 5, 2012) and DT22 (May 5th, 2012) have been added.
QLR Manager now checks the PHP setting called max_input_vars to make sure it is adequate to run QLR.
Excel Binary data export has been improved. The output now calculates column widths and an increased number of fonts, date and numeric formats can be rendered.
Fixes:
Multiple line reports were not working correctly in some cases.
Under certain conditions while executing Macro reports, a row of report data would be displayed outside of the HTML report table.
June 20, 2012 7.2.3
Fixes:
The exporting of objects from one instance of QLR for import into another instance was not working properly.
Fixed a fatal error compatibility issue encountered with PHP 5.4 and several deprecated messages.
May 23, 2012 7.2.2
New Function:
Binary export to MS Excel files now works with numbers that include the currency symbol.
Fixes:
"runMacro" was not finding the graphs directory.
The objects listed in the Macro and Menu Step Builder Assistant were not sorted alphabetically.
May 11, 2012 7.2.1
New Function:
Performance enhancements have been added for large database installations which contain thousands of Tables and Schemas. The refresh of QLR Manager pages, such as the Query Panel, will be faster.
Fixes:
The Average Function was sometimes incorrectly returning 1 as the value.
The list of available Layouts found on the Query Panel was showing blank entries.
April 27, 2012 7.2.0
New Function:
Parent / child Input Controls have been upgraded so one parent can correctly support multiple children.
Improved the version upgrade routine to compare the data structure in QLRtables.php vs. the existing tables as the basis for updating. The upgrade process is now more reliable.
Much faster Layout processing. In addition, if the data caching indicator is present in the header, the report data can be sorted using the + and - characters in the Layout's Display Order fields.
Data caching has been improved for report rendering. The amount of data that can be cached is calculated based on your server's PHP memory and processing speed. Generally, it is between 20 and 40MB of data.
The maximum amount of data cached for a report is now controlled by the qlr.ini setting cacheMB. The cacheSize setting is no longer used.
The Data Import Preview option now displays database error messages when an "Update" Import type is chosen.
The value for the Report Body setting of "auto arrange" is now calculated based on the amount of data returned by the query. "Auto arrange" will automatically move all Break and Group columns to the left hand side of the report, and if the cacheMB memory setting permits, the data will automatically be sorted based on the breaks and groupings applied to the data.
The query comment -- set_cache xx can be used to override the calculated data cache MB value.
The Data Importer is now significantly faster than previous versions.
The Data Importer will now automatically convert currency data, such as $5,434.23 and (€55.69) to numeric data: 5434.23 and -55.69.
When no password is required to access the root ID, a value of [no] can be entered into the Password field during Product Install and on the Connect panel.
"Drill Down" Input Controls now supported. A set of cascading controls can be created, such as first prompting for a Country, then prompting for a region, then finally prompting for a city.
Layout column Actions are now color coded to quickly identify those that have been set. Breaks and Group are blue, Actions such as Sum are green, and Table and Pivots are red.
The MySQL database interface has been changed to retrieve report data as "unbuffered". This allows queries that return huge amounts of data to be executed.
Additional Grouping functions have been added to the Wizard. The functions added are database engine dependent.
Fixes:
Non-English characters were not being handled correctly when using MySQL data in a UTF-8 environment.
The Data Importer was not displaying [New Table] when a schema was void of tables.
Some of the charts in the Help documentation did not have the proper Y-axis label.
The "Return to variables" link was not working for Menu widgets when the qlr.ini pageSource setting was set to "file".
The Form designer was not working properly with Table Column Names longer than 24 characters.
The Wizard now properly handles the assignment of the sort order to Grouped data that has an aggregate function associated to the column.
Existing Wizards were not correctly identifying columns that were added or dropped from a Table.
Parent Input Controls were sometimes not being populated with selection data.
In an Oracle environment, the Report and Output Tools windows were at time displaying a false "Session Expired" message.
The Data Importer was not showing the Preview queries when one of the "Update" Import types was chosen.
In some versions of Firefox, fonts were being rendered as double bold on many of the QLR panels.
January 31, 2012 7.1.2
Fixes:
When adding a new field to the search fields using the Form Designer, the fields were being numbered incorrectly.
December 16, 2011 7.1.1
New Function:
Data caching has been greatly improved for queries with an execution time of over 3 seconds. This allows for Layout changes to be applied to Report Output on a much faster basis.
December 6, 2011 7.1.0
New Function:
QLR Manager is now checking for low PHP Suhosin value settings for post.max_vars, request.max_vars, max_value_length and request.max_value_length. A warning message is now displayed on the Connect panel when encountered.
Object lists, such as Query names, can now be sorted alphabetically or by their last saved date.
A default value can now be specified for query variables found in Widgets and allow the User to change that value when the Widget is executed.
Table index information is now displayed when viewing Table info from the Query Panel.
QLR Manager now displays the object name that is being referenced when creating a widget.
After defining a unique index for a Form, a message is displayed to confirm it is no longer necessary to define the index.
A progress indicator has been added to the processing of large batch queries to both provide status and to keep the browser session alive with the server.
The maximum life of a session with the server can be set by adding maxLife = (minutes) to the qlr.ini file.
Support for equals and not equals NULL and empty (two single quotes '' as empty) as input filters in the Form and Wizard search panels has been added.
The Data Importer now checks the PHP max execution time and loads data in chunks to prevent running out of time.
"Skip" paging buttons have been added to reports. These allow the User to quickly move through large amount of data. Skipping works by moving from the current page halfway forward to the last page or halfway backward to the first page.
Server processing time to create a report page has been improved significantly. Final rendering is still dependent upon your browser's speed.
Fixes:
When surrounding a Textarea input control with quotes, the values would have a leading space when the input value started a new line.
A database error message has been added when a QLR object cannot not be found.
QLR now accounts for an empty date field when importing data.
When first connecting to the Wizard panel, then going to the Query panel, no databases were being displayed.
The Return to variables link was not being displayed once you paged forward in the report output.
Fixed problems with some Report Object functions caused by internally changing database connection method.
MS excel binary export options was using Julian date calculation. This has been fixed to be the Gregorian date calculation.
MS Excel binary export can only support text input up to 255 characters. QLR Manager now truncates the input to this length. Exporting information that contains data strings longer than 255 characters can still be accomplished by using the "tabbed" data output method.
QLR Manager was not behaving properly when installed in the public schema of a PostgreSQL database.
Deleting a record using a Widget based Edit Form where the initial search only found 1 record, was not working properly.
October 3, 2011 7.0.0
New Function:
All database engines can now be accessed from a single instance of QLR Manager. QLR objects, such as Queries, Layouts, etc. are managed separately for each database engine.
Report data can be saved as a database table. When saving, the data can be saved to a different database engine. For example, a report created in MySQL can be saved as a table in Oracle.
The Saving of data as a Table has been added to Macro step output options.
Fusion Charts support has been added. QLR Manager is now packaged with an evaluation copy of FusionCharts. The User can create charts using jpGraph, FusionCharts, or see both chart types at the same time to decide which charting package best presents their data.
Form access can be controlled by "dynamic validation". One example might be a query added to the validation process that prompts the User to enter their password and user ID that is found in a separate table. In addition, data from that separate table can be used in the Form, including hidden search elements. As a result, the User can be limited to accessing only data related to their user ID.
Two new Layout Format types have been added. Formatted will render text as though it contains HTML tagging for line breaks. Line feed characters found in the raw text input will be replace by HTML break tags (<br />). This prevents the unwanted word wrapping of text. The Textarea option allows the User to specify an HTML textarea box to display large amounts of information in a report. The textarea will include a scroll bar.
A Layout Column Action called Unique has been added to the list of Report Column actions. It counts the number of unique occurrences of data in a report column.
The Data Import function has been improved. Several new import types have been added: Insert when new, Update existing data records, and Update existing records when unique. Data filtering in the import process has also been improved: Multiple criteria entries, separated by commas, is now available.
Improvements added to Wizard and Form Designer allowing columns to be rearranged using drag and drop.
October 3, 2011 6.1.9
Fixes:
The Wizard was not properly recognizing the "Is blank" and "Is not blank" filters when the associated criteria field was blank.
Due to the many different MS Excel binary data formats, the older method of exporting data to Excel using "Tabs" has been added back into QLR Manager.
QLR Manager was not handling data correctly when data with the same table column name was being selected more than once in a query.
The "user session" query was not properly executed in all instances.
The &n (Next) reference used in the Layout is now being reset to blank each time a query is executed.
August 12, 2011 6.1.8
Fixes:
The Query Variables panel was incorrectly displaying hidden Parent Input Controls when the User used the "Return to variable" option from a Query Widget.
The Object Names were not being associated to the proper Object Owner when QLR Manager was being used in a case sensitive database environment.
The Excel export options were dropping data for fields that contained a "<" character that was followed by a non-blank character. Excel was treating this data as an HTML tag.
August 2, 2011 6.1.7
Fixes:
Query Widget creation using Report Tools was not always referencing the currently selected query.
Query variables were not always being properly identified when a Query Widget was being created.
Query Widgets containing hidden parent values when parent / child controls were present, are now working properly when the Widget is executed from a Menu.
The Oracle database driver was not properly deleting aged Widgets.
June 24, 2011 6.1.6
Fixes:
The Header Tab buttons now allow for a wider range of font metrics, particularly in Windows 7.
The export to MS Excel was broken when the data being exported contained line spacing after a report Break.
A Return to Menu link has been added to widgets being run from the same HTML page frame.
The object owner (login ID) is now being treated as case insensitive. Logging in as "TOM" will have access to the same QLR objects as "tom".
April 20, 2011 6.1.5
Fixes:
The Wizard was not remembering proper join columns in some instances.
Form fields were not being populated with data when using SQL Server Tables / Databases that were defined to be case sensitive.
Fixed widgets generated with older versions of QLR Manager that contained hidden parent control values.
Fixed problems related to using Internet Explorer 9 (IE9).
The Submitted Values link on the Input Control preview page was not working properly for radio button and checkbox controls.
There was a Report Tools error when trying to download XLS data files.
Report paging in multiple page reports generated by a widget was broken.
Excel data file creation was adding blank lines after each page.
Menu widgets can now be executed without a header within an HTML iframe.
January 6, 2011 6.1.4
New Function:
Pie Slice labels can now be manipulated by using the X axis Font Size and Display Frequency settings.
Fixes:
The PostgreSQL installer was not working properly.
There was an HTML error when rendering Left aligned Input Controls.
The optional Form Password Page was not displaying the proper text prompts.
An error in mapping Input Controls to their proper Owner when creating a Macro Widget has been fixed.
QLR Manager can now work with SQL Server Databases that have been defined to support case sensitive Table and Column names.
December 23, 2010 6.1.3
Fixes:
When previewing a parent / child input control, the initial child list did not display the values that belonged to the default parent value.
Under some circumstances, starting QLR Manager right after creating a new installation would result in a blank page being displayed.
December 13, 2010 6.1.2
Fixes:
Additional changes made so that QLR Manager can be run without having to change the php.ini file "error_reporting" setting to contain ~E_DEPRECATED.
December 1, 2010 6.1.1
Fixes:
Account for functions (such as ereg and set_magic_quotes) which are now deprecated in php 5.3. This also requires that the User's php.ini file "error_reporting" setting contains ~E_DEPRECATED as an option to suppress php warning messages.
November 5, 2010 6.1
New Function:
All QLR Manager messages and text have been placed into external files, allowing for translation.
The specific Input Control referenced when a Widget is created are now used when the Widget is executed.
When creating a Master / Detail Form, it is no longer necessary to include the fields in the Detail Form that link the data to the Master Form.
When a Checkbox Grid Input Control is created, the width of the displayed data can now be set.
The Form data search panel will only display the Comparison choices and Sort choice when necessary.
Report data columns can be wrapped across multiple rows.
The size of widget links has been greatly reduced.
The Data Importer now supports case sensitive data load filtering.
The MS SQL installer now checks to see if "free TDS" is installed and provides a warning message.
Microsoft Excel files are now created in a native excel binary format.
The Query Text for Input Controls that are defined as a Report Object can now be dynamically changed.
Sub Titles can be added to charts by adding an HTML break tag, <br>, to the title text.
Fixes:
Date fields that have their initial data set to '0000-00-00' are now handled properly by the pop up Calendar Input Control.
When a Form contains an Input Control that utilizes an Evaluated Formula, the data is now processed correctly.
Object lists now take into account case sensitivity of Owner names.
Improved speed when executing long running Oracle queries.
The Query Wizard now accounts for non-alphanumeric characters in table and column names, such as periods.
The Report Object function of setControlQueryVar has been added. This allows for a query variable found in the query text of an Input Control to be set at runtime.
October 19, 2010 6.0.8
New Function:
The User can now be directed to a different page when the Logoff button is pressed. This is accomplished by adding an entry for logoffFile to the qlr.ini file, such as logoffFile = http://www.mysite.com.
Fixes:
The data sorting option on the Form Search panel was not working for deployed Forms. It was only working in Preview Mode.
A bug introduced in V607 associated with downloading Report Data files has been fixed.
October 15, 2010 6.0.7
New Function:
The Form audit trail table now contains the unique index values from the records being changed as a way of allowing the User to backtrack to the original data.
Fixes:
Parent / Child input controls were not working when the control Name was prefixed with the Owner.
Single quotes were not being rendered correctly when using an Oracle database.
QLR Manager now accounts for non-alphanumeric characters, such as a period, used in SQL Server database object names.
Forms were populated with incorrect data when returning from the error message page.
QLR Manager now checks for the maximum PHP textsize setting when used with SQL Server. This will prevent data truncation.
August 16, 2010 6.0.6
Fixes:
Removed the display of an error message that was being generated by the installer.
Fixed error that may be generated when trying to save an Input Control.
Creation of query based selection lists for an Input Control was not working properly under some circumstances.
May 21, 2010 6.0.5
New Function:
The ability to execute MySQL stored procedures using the CALL command was added.
Fixes:
Fixed child input control behavior when the parent control value is predefined and used in a widget link.
FormEdit.php was calling an undefined function called getTxt().
March 18, 2010 6.0.4
New Function:
The Chart label truncation option for the X-axis and Legend values has been expanded from 12 to 25 characters.
Fixes:
The Small Business edition license was erroneously performing User Authority checking.
The option to create a widget for a batch query was missing.
Fixed Form searching when a table column was only defined as part of the search portal.
Under some conditions, when pressing the "Return to Search" option on a Form, it would bypass displaying the Search Portal.
February 22, 2010 6.0.3
New Function:
Numerous new chart sizes added. Chart sizes, in pixels, now include 200x150, 300x150, 400x150, 250x200, 400x200, 500x200, 300x225, 450x225, 600x225, 400x300, 600x300, 800x300, 500x375, 750x375, 600x450, 900x450 and 800x600.
Fixes:
Fixed width data exporting was dropping off the last character per line exported.
The Form Designer was not remembering changes the User was making prior to selecting a detail form for use in a master/detail form type.
A 'Return to Menu' link was added to the Form's search panel when a Form was being called from a menu widget.
Running a Macro from a Menu was resetting the name of the Macro on the 'Create Macro' panel.
It was possible to proceed past the Connect panel to the Macro-Menu-Form panel with an incorrect userid and password by pressing the Connect button more than once.
SQL server VARCHAR fields > 255 characters must be "CAST" to TEXT due to PHP data truncation at 255 characters.
Query variable values that contained quotes were not being handled correctly.
Fixed problems found when an object name contained an apostrophe.
January 31, 2010 6.0.2
Fixes:
Values for query variables with a related input control were being set as empty when using MS SQL Server.
Form widgets were not sorting data as defined in the Form Designer.
The 'Between' comparison option in the Wizard was not properly working with query variables and quoting.
MS SQL Server CHAR data contains trailing blank spaces which needed to be removed.
The selection of User IDs on the User ID Admin panel was not working.
January 28, 2010 6.0.1
Fixes:
QLR Manager was not properly handling SQL Server database names that contain a period.
Under some conditions, Input Controls could not be retrieved.
December 23, 2009 6.0
New Function:
Introduction of the Form Designer, which supports the editing of data in a Database Table. Three kinds of forms can be generated: Tabular, Free Style and Master/Detail. Master/Detail forms provide the ability to edit related data from two separate tables at the same time.
Google Chrome and Apple Safari are now supported browsers.
Data importer enhanced to provide more flexibility when selecting data to load.
Data importer initial file reading performance greatly improved. Acquiring data is now at least 10X faster on large files.
When initially accessing QLR Manager, or when cookies are turned off, QLR Manager will populate the server and optional database reference fields on the Connect panel with the values found in the qlr.ini file.
Improved the opening and closing management of the Output tools and Report tools pop-up windows when working with Linked Reports and QLR Widgets.
The Enterprise Edition supports the setting of query execution restrictions, such as allowing a User to only execute SELECT queries.
Several enhancements were added to charting. The User can now define the font sizes for the Title, X-axis and Y-axis labels. The number of labels to spread across the X-axis can now be specified. Anti-aliasing is applied to line graphs when a line thickness of 1 is selected.
Fixes:
Linked reports were not working properly when multiple reports, referencing different databases, were used when creating a Report Object.
Macro widgets were not working properly when the database referenced in a macro was different than the connection database at the time of creation.
The Report Columns section of the Layout Panel was missing when running a query from a menu.
Report Link Output header text would not allow double quotes.
Query Variable string replacement, when a child input control was used for the Query Variable, was not substituting the proper value.
When a query was first executed and the number of data elements retrieved for the report exceeded the cacheSize setting in the qlr.ini file, and an input control was used in the query that utilized query text to produce it's data source, the report output consisted of blank cells once the cacheSize data (default of 5000 elements) was exhausted.
August 30, 2009 5.6.4
Fixes:
Fixed error message of undefined variable queryVars in Report.php that was visible when the qlr.ini ShowErrors is set = Yes.
Oracle report links were not executing, but were instead showing the QLR Manager login panel.
Wrong button set would appear when using a Basic Edition license under some circumstances.
When creating multiple widgets immediately after saving queries, the wrong query was being used to produce the widget.
May 12, 2009 5.6.3
New Function:
Added code to address Mysql Database error 1104 : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay.
Improved handling of data while running multiple sessions of QLR Manager simultaneously.
For Postgres User debugging purposes, QLR Manager now displays database connection errors.
Fixes:
Fixed a problem in Macros where steps with query errors were not producing any output.
Retrieving Input Controls for Report Objects was not working.
Use of a primer database reference in Postgres was not working properly when a database name was not provided.
Sometimes QLR Manager would generate Javascript code for the function isDelete() that contained an error.
Incorrect button sets where being displayed after running a macro, that contained query variables, from a menu.
March 28, 2009 5.6.2
New Function:
A user can now run multiple sessions of QLR Manager at the same time using the same browser.
The Layout Actions of Sum, Cumulative sum and Average can now be applied to Time datatype fields, when formatted using the 22:59 and 22:59:59 date formats. It also supports decimal places for seconds when the 22:59:59 format is used.
QLR Manager now checks to ensure that PHP GD True Type Font support has been installed in Unix based systems.
QLR Manager now checks older versions of Unix based PHP, which have been compiled without the --enable-memory-limit directive, for a low memory setting.
Added a warning message to the Connect Panel about possible session expiration problems when the php.ini setting of session.use_trans_sid is set = On.
Fixes:
Creating Pie charts without specifying a legend value was producing an error.
In some instances, QLR Manager could not detect the browser type and would create error messages in Report Objects.
A file path issue in QLR Manager was being created when a Report Object and the QLR Manager User interface were being run in the same session.
Input controls with a min / max check were not working properly in some server environments.
The "#" character is no longer used as a comment indicator in a query when using MS SQL, as a "#" is used by MS SQL to identify temporary tables.
The Data Importer was not working properly with Oracle.
The Wizard was not handling PostgreSQL Table and Column names that contained uppercase characters.
The external access macro interface, runmacro.php, was not finding Macros belonging to a pseudo ID.
When runmacro.php was issued from a command line, it was not processing query variable name / value pairs in php5 environments.
When runmacro.php was issued from a command line, charts were not being displayed if sent as in-line images in an e-mail.
The "Average" calculation was not working properly when certain Layout options were applied to the report data.
Custom Layouts with multiple page sets of output, were only displaying the last page set when the <report> parameter was used.
In some instances, a blank screen, as opposed to an error message, was being shown to the User when creating a chart that contained an error.
February 20, 2009 5.6.1
New Function:
Option added to Layout to ignore the sorting of data spread across the page for Table and Pivot Layouts. The data appears in the original order as found in the report rows.
MySQL drivers updated to support the executing of procedures when entered into the Query Panel.
QLR Manager now updates the query list with queries that may have been created by other users, each time you access the query panel.
When defining Report Objects, the include path reference of "qlr_inc_path" can optionally be used to avoid interfering with other application's use of the term "inc_path".
Fixes:
Fixed bug where table references in wizards were sometimes getting double prefixed with a table reference, such as c.c.order_item.
Fixed the situation with child input controls where the child has no values for the initially selected parent. The initial list will display as blank, with the value = ''.
When a widget window is closed, it now closes the session, preventing session time-out errors.
Fixed problem where PDF file creation was not working in database mode.
December 19, 2008 5.6
New Function:
Macro output can be formatted using custom HTML to combine several reports into a single customized layout.
QLR Manager is now "Cross Domain" compliant, allowing Widgets to be embedded into Content Management Systems, such as Drupal.
Fixes:
The Wizard Comparison type of Null and not Null were requiring that comparison text be entered in order to work properly.
Break level data was not being evaluated properly when using the Formula Layout Action .
Updated the error message generated when a MySQL max_allowed_packet error was encountered to state that the problem is with the MySQL setting on the database server where QLR Manager is installed.
December 1, 2008 5.5.4
New Function:
runmacro.php can now be executed from non-URL oriented cron jobs with arguments. The format is:
runmacro.php [macro owner] [macro name] [query variable name 1] [query variable value 1] etc...
The include path for Report Objects can optionally be specified as 'qlr_inc_path' instead of 'inc_path'. This can be used instances where 'inc_path' is in conflict with other applications.
Fixes:
Query Widgets that returned multiple pages of data returned an error message of "Report paging is out of synch with current Layout" when trying to advance to the next page set.
November 10, 2008 5.5.3
New Function:
Report links can now be conditionally created.
Fixes:
Wrong database connection values sometime used when executing a macro widget, resulting in a 'Not linked to database' error.
Macro widget creation from a menu is now suppressed. This situation was causing the creation of improper macro widget links.
October 11, 2008 5.5.2
New Function:
Ability to customize a widget by manually adding query variable values.
Fixes:
Pseudo IDs not behaving properly when switching from the Menu panel to the Query panel.
Data Importer not working properly with pseudo IDs.
Resetting a Wizard not working properly with pseudo IDs.
September 24, 2008 5.5.1
New Function:
Ability to password protect a widget.
Fixes:
Upgrade engine was not recognizing the database update to migrate from v5.4.2.
Query variable substitution in Layout text was not working properly in widgets.
Widget execution not properly handling Macro step level query variable assignment.
September 5, 2008 5.5
New Function:
Ability to create Widgets to directly access queries, macros and menus from outside of QLR Manager.
Ability to control the display order of Input Controls was added.
Legend font size is now adjusted when the legend is placed on the right hand side of a chart, to account for numerous legend entries.
Fixes:
Table Layout breaks not taking into account columns set to a zero column width.
X axis title creation was failing under certain versions of PHP for Horizontal Bar charts.
Macro output types that included Plus signs (+) were not being recognized properly.
July 19, 2008 5.4.2
New Function:
QLR Manager login IDs (pseudo IDs) can be created, utilizing an existing database ID to make the database connection.
Fixes:
Doubling of back ticks being placed around wizard databases objects has been corrected.
Installer now works when a license file contains multiple domains.
Using double quoted values in a Wizard's filter set was not working properly.
May 28, 2008 5.4.1
Fixes:
The Report Object function addAttachments was misspelled as addAttachements.
In some operating environments, the e-mail code was not working properly to send reports as e-mail.
May 16, 2008 5.4
New Function:
The PDF output generator has been upgraded to html2ps v2.0.42. Improvements have also been made to help keep the session alive between the client and server when longer running PDF generation is encountered.
Fixes:
The "% of total" Layout column action was not working properly in Table and Pivot Layouts.
Report Object download file creation was not working properly.
The Font Face selection list was not displaying the correct options.
May 7, 2008 5.3.1
New Function:
The ability to selectively turn on and off the ignoring of query variable bracketing within a query has been added.
Report Links used in Report Objects can now target the same window.
Fixes:
The "Run with Layout" control was not supplying proper Layout name.
Report links were not working properly when used in Report Objects.
April 26, 2008 5.3
New Function:
Report links are now "portable", meaning that reports containing report links can be e-mailed, downloaded as HTML, or used in a Report Object.
Data Import capability has been added to the Enterprise Edition by logging on to "User ID Admin and Tools". This supports the importing of data from delimited (comma, semi-colon, tab, or space) and fixed width data files. Data rows can be filtered for selective loading.
Ability to create parent / child input controls to dynamically change the available selections in the child control based on a selection in the parent control.
A new encoding technique has been employed that no longer requires the Zend Optimizer or ionCube loader files.
QLR licensing no longer requires that a specific database engine be specified. A single license will now work with any of the databases supported by QLR Manager. However, to use QLR Manager with different database types still requires a separate installed instance for each database.
The appearance of QLR Manager can be altered by setting the color scheme for the background, section and section border colors.
Two new date formats have been added to the Layout formatting: 2001/Q4 (year and quarter) and 2001/52 (year and week).
Three new statistical Layout Actions have been added: Median, Mode, and Mode(cnt), which includes the count of the Mode value.
It is now possible to create multiple PDF files from a single Report Object file. In addition, output directory can be specified for Report Object PDF file creation.
The fill page with rows option now supports the ability to fill with all white, colored or striped rows.
Added a faster method of creating XML and Data file (XLS, CSV or TXT) output from Report Tools. This method bypasses the use of the Layout formatting and directly uses the query results.
Fixes:
The Wizard was not able to gather column information on large tables with several million rows.
Under some conditions using certain browsers, the calendar input control would freeze.
When qlr.ini was configured with pageSource = file, PDF creation from Report Tools was producing a blank page.
The Report Tools pop-up for linked reports was incorrectly loading the Output Tools set when Report Tools should have been presented.
If a single Layout Action was being applied to the first column in a report, the results were not being displayed.
Eliminated unnecessary database connections that QLR Manager was making.
PDF file creation was not properly working with Report Objects.
February 16, 2008 5.2.2
Fixes:
The Wizard was not able to gather column information on large tables with several million rows.
Under some conditions using certain browsers, the calendar input control would freeze.
The Report Tools pop-up for linked reports was incorrectly loading the Output Tools set when Report Tools should have been presented.
February 5, 2008 5.2.1
New Function:
Report page sizes can now be based on either the number of data rows selected, or the number of rows resulting from word wrapped data. The impact of word wrapped data can now be ignored.
The setting of presetServer can be manually added to the qlr.ini file. This defines the server to be used on the Connect panel and eliminates the need for the User to enter the DB server value.
The minimum number of selected items, or characters, can be specified for an Input Control.
The number of entries that triggers the presentation of the [Select all] [Deselect all] [Reverse] control for a multi-select list or checkbox group type of Input Control can be set.
Report Object PDF file creation has been enhanced with the addition of the functions setPDFfilename() and setPDFdestination(). The destination can be either a browser download dialog or the output directed to a file.
Report Object function getQuery() has been added to help debug a Report Object that is not producing the expected results.
Report Objects now support the creation of XML file and data output. The functions setXMLRecordTag() and setXMLRootTag() have been added to support XML creation. The functions getFileData() and getOutputFile() have also been modified to support XML output.
QLR Manager can now run within an existing user environment that is already managing a PHP session, with the setting of a variable $QLR_NO_SESSION='no' in the existing session.
Complex formatting can now be applied to the break text in the report.
A pop up text editor has been added to several Layout fields to make the editing of large amounts of text easier.
Report links can now be used in the "across" data in a Table layout.
The qlr.ini value DBlogin can be manually edited to allow for a pre-selected connect database to be specified.
The addition of a special Input Control called qlr_server_list has been added to allow for the building of a selection list of available servers for a given installation.
Fixes:
The install program automatically tries to set the php magic_quotes_runtime setting to "off" to avoid database install errors.
Report Object function createReport() was not resetting the first row of a report's data if executed a second time.
Break data that summed to zero was not appearing.
Eliminated the trailing blank page in PDF output.
December 1, 2007 5.2
New Function:
Linked Reports added which allow child reports to be spawned from a parent report.
XLS and MS Word file download format improved with graphs now embedded in the download.
The Layout supports defining the vertical alignment of data in a report column.
The display order of columns in a report can be controlled in the Layout, avoiding the need to rewrite queries to change the report column order.
The keyword [all] has been added to input controls to allow for the pre-selection of all values for checkbox sets and multiple selection lists.
Report Object function sendMail() updated to handle file attachments.
The functions addAttachment() and getFileData() added to Report Objects.
File clean up now occurs on a random basis, resulting in faster initial connection time.
Evaluated formula capability added to Input Controls.
Fixes:
Mozilla session expiration problem when cookies were not allowed.
Pivot report format was not counting total page rows correctly.
It is no longer possible to save a query with a blank name.
Evaluated formulas in text after the break now work properly.
Default query variable values were not working properly in Macros.
July 28, 2007 5.1.5
New Function:
Input Controls can now include a JavaScript regular expression to validate or alter data input. Custom messages can also be defined to accompany the regular expression execution.
Selection limits for checkbox sets, multi-select lists and character limits for text area Input Controls can be defined.
The function getSQLdate() has been added for report object date conversion to return a database friendly date format.
setControlValue() has been added to support the setting of numerous Input Control field values when used as report objects.
replaceNameChars() has been added to replace converted special characters in report object Input Control names.
Layout column counts no longer need to match the query column counts, allowing for greater flexibility when choosing a Layout to apply to the query results.
A Layout Action called Formula has been added. This allows for columns with evaluated formulas to be included in reports when the "Group" Action is present.
E-mail output enhanced to overcome MS Outlook 7 HTML rendering shortcomings.
Pseudo IDs can be created. This allows for multiple IDs to be created without the need to establish underlying database IDs and passwords. The pseudo IDs utilize the master QLR ID and password to connect.
Fixes:
Explicit mime types for file downloads have been added to fix OSX/Safari download issues.
QLR Manager now resets session variables when the connecting database server name or server path changes.
Charts were not being archived under certain server configurations.
Usage tracking was not working properly when items were run from a menu that was called from another menu.
Users were able to access Input Controls via the pop up window even if they were not granted authority to do so.
Input Controls containing dashes in their saved names were causing JavaScript errors.
June 2, 2007 5.1.4
New Function:
The text font for individual charts can be specified in the Layout.
The User can specify in the Layout to fill a page with empty rows after the last data row so that all report pages are uniform in size.
Fixes:
When selecting 3 or more tables to be joined in the Wizard, the table referenced in the join section was table "a", which was not the correct table for join definition.
The Wizard was not generating the proper SQL for Right Outer Joins when the right hand table was previously defined in another table join.
Formatting of null values in numeric fields was rendering formatted zeros instead of blank entries.
May 21, 2007 5.1.3
New Function:
Added ability to selectively change or omit the Run button image in user menus.
A -- no result keyword can be added to a query to display a user defined message when no data rows are found.
Input controls using multi-select lists with 6 or more values now have [Select all] [Deselect all] [Reverse] controls.
Data Export now allows the Destination Database Engine to be selected, with the resulting SQL syntax in the export file altered for the selected DB.
Fixes:
When returning to the Create Menu panel from the Preview panel, the wrong header was being loaded.
April 24, 2007 5.1.2
New Function:
Page breaks added between Macro steps to allow for proper pagination when printing.
The maximum number of report rows to display in a page set can now be specified in the Layout.
Formatting of report output enhanced to support PDF printing when using a PDF writer such as Adobe Acrobat or CutePDF.
Changed default to print reports in color which facilitates easy printing to PDF using a PDF writer.
Fixes:
The Oracle version of the qlr_usage_log table contained a typo in the field "object_type". It was incorrectly called "objecyt_type".
Query names where not being updated to reflect changes between upper and lower case letters.
Plot+ was not formatting the numbers correctly that appear above a plot point when used in a Table Layout.
Wizard data filtering was not working properly when Input Controls that support multiple value selections were used.
The Text Before a Break was not responding to Right or Center alignment.
Wizards, Macros and Menu items were not finding shared Input Controls that belonged to other users.
Specifying the display of only the vertical inner borders in a Layout was not working properly.
April 5, 2007 5.1.1
New Function:
When executing a query that uses query variables, the "Return to variables" link is now presented in the report output even when there was a query syntax error or no report rows were generated.
Fixes:
When using an input control with a checkbox grid, the controls for [Select all] [Deselect all] [Reverse] were not working properly.
The Table info control within the Select Database selections was not working properly.
March 25, 2007 5.1
New Function:
Support for MS SQL Server introduced. Requires the use of "SQL Authentication" for user ID's. This has been tested on both SQL Server 2000 and 2005.
Wizard page join columns that are part of an index are now color coded.
Object usage, such as for queries and macros, can be tracked in a table called qlr_usage_log.
Improved PDF file creation, including the ability to place a "watermark" on a PDF report.
Significant reduction in the number of cascading style sheet(CSS) entries necessary to format a report.
Ability the control the number of report pages to be viewed horizontally in the report output.
Ability to name Macro file attachments.
Ability to delete Wizard join column pairs has been added.
The columns available in a Wizard for inclusion in a report can now be sorted alphabetically, or in table sequence order.
Improved distribution e-mail support.
Link to "Return to Variables" added to report output panel when Query variables used.
Last Report Tools values entered for a User ID are saved as user preferences.
Fixes:
Preview Tools were not working properly when previewing a Macro or Menu.
Size of the custom text field was expanded to handle large custom Layouts.
Report Object Block size control was not working properly.
Session was expiring when processing large reports using Report Tools.
November 17, 2006 5.0.6
New Function:
When using evaluated formulas in a layout, the data in a prior row can now be accessed by using $pvalue to reference the column's prior row data and the $pval[ ] array can be used to reference all the fields in the previous row.
Fixes:
Improved performance using distribution e-mail and enhanced status messaging.
Reports created from batch queries were not accessing additional report pages properly.
Under certain circumstances, report break information was being rendered outside the report table.
November 12, 2006 5.0.5
New Function:
An SMTP mail server can be defined for use, including the port, a User ID and Password.
Fixes:
Modified the sorting of multiple Input Controls to sort by control type, and within each type, map the sequence of the control to its position in the query text.
Better handling of session expiration will retain the User ID and DB server values on the Connect panel.
Report Object function setBlockSize() was not working properly.
October 23, 2006 5.0.4
New Function:
Wizards now offer the capability to select tables and omit the database prefix to create generic templates for use across common table structures.
The comments-- suppress_on and -- suppress_off can be added to batch queries. This instructs QLR Manager to suppress the echoing of status messages when queries are executed. This allows for the creation of temporary tables, insert queries, etc. prior to executing a report generating query.
Fixes:
When adding report columns to the Wizard with multiple table joins, the column selections were not incrementing correctly to the next table.
October 16, 2006 5.0.3
New Function:
Checkbox Input Controls that have more than 10 check boxes now contain links to Select all, Deselect all and Reverse selections.
The number of columns for vertical Radio Button and vertical Checkbox Controls can now be specified by entering 2 through 5 (1 column is still the default) in the Text input size field on the Input Control panel.
Evaluated Formulas are now applied to Break level and the Final Summary information.
Fixes:
In some instances, the Tabs in the QLR Manager header were not being displayed.
Under certain conditions, the installer was reporting that the MySQL max_allowed_packet size was not sufficient to continue with the install.
Oracle installs were not properly loading the font selection values. Users applying the upgrade package should review the readme.txt file for instructions on correcting this situation.
October 9, 2006 5.0.2
New Function:
Added flexibility to omit the database prefix for selected tables when using the Wizard.
Fixes:
Fixed database connection issues when using the Wizard with PostgreSQL.
The option to download PDFs from Report Objects was not functioning correctly.
Session expirations are handled more reliably by resetting all session variables at logon.
The installation program was giving an inconsistant error message for MySQL, stating that the max_allowed_packet setting was not large enough.
October 1, 2006 5.0.1
New Function:
New query variable [qlr_userdb] was added that can be used as a query/wizard variable and with input controls.
Fixes:
Fixed erratic behavior related to database connections when using the Wizard.
September 24, 2006 5.0
New Function:
The Query Wizard is introduced. It allows users to author queries to build reports without any knowledge of the Structured Query Language (SQL).
Input controls can be created or previewed on the fly when authoring queries using either the Query editor or Wizard.
Page rendering performance is significantly improved with changes in the User Interface and a reduction in the number of database transactions QLR Manager performs.
Columns in a report can be automatically rearranged based on column actions such as Breaks, Sum, etc.
The Break Summaries where only a single row of data is present can be suppressed to produce "Tighter" reports.
Query Variables can be specified using brackets, such as [start date], which allows spaces in the variable or input control names. The older style **query_variable format is still supported.
The desired output character set, such as 8859-1 to 8859-16, utf-8, etc. can be specified for QLR Manager generated pages.
QLR Manager data tables for storing queries, layouts, etc. can be defined as UTF-8.
A Lightweight Directory Access Protocol (LDAP) PHP interface has been added for those who would like to increase their user logon security. It is also possible to use this function to perform ID replacement based on information managed in their directory.
To support MySQL hosting environments that require a database name be provided when connecting, an installation option to prompt for the database name on the Connect panel has been added.
Fixes:
QLR Manager did not respond properly when the browser's Back button was used to return to the Macro or Menu panel from another web site.
Running the installation program in Mozilla incorrectly returned the User to the initial installation panel.
PDF page breaks were not being handled correctly when only the final break text was on the last page.
The Input Control panel was not displaying default values properly.
Single quotes used in QLR Object names were not being handled properly.
Numerous other small fixes.
April 30, 2006 4.1.5
New Function:
A message has been added to the multiple select list Input Control to highlight that Shift+click selects a range of entries.
Oracle installations no longer require that a TNS listener be running to use QLR Manager.
Back tick support added for MySQL to allow for the QLR Manager master database name to contain hypens and other characters that need the back ticking syntax.
Fixes:
A "%" will now signal the end of a query variable so it can be used with the sql like command. Example: like '%**lastName%' can return like '%Henrik%'.
Nested menus where not working properly with Oracle.
QLR Manager now accounts for mixed case when finding a userid profile.
Menus without a title were creating a cascading style sheet error.
March 26, 2006 4.1.4
Fixes:
Oracle Analytic functions were not working when an 'order by' clause was used in the syntax.
Final page in a page block set was not being filled with rows of data to form a complete page.
Break values were not being reset properly when the last row of a page block contained break information.
When switching ID's, user authority levels were not properly set for the new ID in certain situations.
March 5, 2006 4.1.3
New Function:
Excel and Word Document file types can be defined as an output type in a Macro step.
The output from a Macro step can be written to a file.
A Layout Column Action of "Table-" has been added. This allows for Table Layout reports to be created without the summary columns that normally appear on the right side of the report table.
Fixes:
Column widths set to zero were not formatting correctly with some output file types.
Charts were not being archived properly when "in-line" charts were specified for e-mail creation.
The testing of chart creation during installation was not functioning with web sites using an https connection.
Only one chart at a time could be created in a single Report Object instance. The last chart would overlay the preceding charts.
Cascading Style Sheet entries were being omitted when the "add" option was used in a Macro step.
February 12, 2006 4.1.2
Fixes:
A Javascript error was being thrown when attempting to preview a "numeric only" text input control which prevented the control from functioning correctly in preview mode.
The popup calendar input control was not consistently initializing with the date displayed in its associated text input.
January 27, 2006 4.1.1
New Function:
The direct socket connection method for distribution e-mails can be disabled by adding the entry "useSocket = No" to your qlr.ini file.
Report Tools now displays a status message as distributed e-mails are sent.
It is now acceptable to apply a layout in the query panel to "SELECT" queries that are part of a batch of queries.
A DBfilter of **omit** can be specified in your qlr.ini file to prevent the display of the database / schema list. This is helpful in large Oracle installations which may contain thousands of schemas.
Fixes:
The query results data cache is now being used more efficiently for report paging and Report Tools output.
In some instances the last distribution e-mail was not being sent.
January 2, 2006 4.1
New Function:
The Oracle version of QLR Manager is now priced the same as the MySQL and PostgreSQL versions.
A popup calendar Input Control has been added to gather date variable types.
Input Controls can now be used with Report Objects.
Limited size PDF files can be created using Report Tools and Report Objects.
sendMail() has been added as a Report Object function.
XLS and DOC file types have been added as Report Object download types.
A Layout format to unserialize php serialized array data.
The page row count is now adjusted for word wrapping in a text field.
The source query or macro name of a menu item can be found by holding your mouse pointer over the menu item.
Fixes:
Setting smaller column widths in Report Objects was not working properly.
September 25, 2005 4.0.1
Fixes:
Report Tools message when completing distribution e-mails was not working properly.
Query variable page not reacting properly when a single query variable, without an associated input control, was submitted by pressing the Enter key.
September 17, 2005 4.0
New Function:
Integrated "e-mail merge" (distributed e-mails) introduced. This allows for the creation of reports to be created and individually e-mailed to recipient's based on e-mail addresses managed in your data.
Custom report layouts support the creation of "free form" reports where individual data items can be referenced, as well as the embedding of entire reports and charts. Full HTML tagging is supported.
Pivot layouts, which rotate columns of report data into rows of report data has been added.
Input controls, available in the Enterprise Edition, consisting of radio button sets, checkbox sets, drop down select lists, text areas, and text input fields can be created and integrated into queries to collect information to be processed when a query is executed.
Product installation allows the User to specify the true type font file names that are to be used for normal and bold chart text.
Separate color schemes can be applied to "lead in" and Break text.
Expanded to work with Oracle 10g.
Word wrapping for Break text can be set to on or off.
User ID administration, available in the Enterprise Edition, has been integrated into QLR Manager. The authority to manage User IDs can be assigned to IDs other that the Master QLR Manager ID as well.
Data Export, available in the Enterprise Edition, has been integrated into QLR Manager.
Fixes:
The Sum Action was not calculating properly when both Breaks and Groups were specified in a Layout.
Scatter chart X and Y titles were not being switched properly when Scatter chart Y column set to 1st plot.
Pressing a header tab on the Query variable input panel, now works properly.
Error handling for incorrectly including jpgraph files for charting has been added.
The Average Action was not displaying the proper line item level values unless a Group Action was present.
July 16, 2005 3.1.6
Fixes:
Chart image URLs in an https environment were not being properly referenced.
The Cascading Style Sheet (CSS) entry for triggering printer page ejects was missing in report objects.
Menu previewing was not working correctly when the User did not have both Macro and Menu create authority.
July 1, 2005 3.1.5
New Function:
Enabled the use of the special variable **qlr_userid in Macros to allow for the substitution of the logged on User ID.
Fixes:
Improved output e-mail performance when multiple recipients specified.
Increased the PHP memory_limit at runtime for memory intensive operations such as creating charts. This caused the browser to hang under some conditions.
June 1, 2005 3.1.4
Fixes:
Install program now accounts for the change in the MySQL password storing method that was introduced in MySQL version 4.1.
External macro access now works for PHP instances that have "magic quotes" turned on.
Under some conditions, external macro access was unable to locate graphing files.
May 22, 2005 3.1.3
Fixes:
"Chart only" output was causing collapsible sections in Macro output to render incorrectly.
Minor help manual corrections made.
May 16, 2005 3.1.2
Fixes:
Database selection list values were not always appearing on the Define Macro and Create Menu panels.
General performance and stability improvements introduced.
May 1, 2005 3.1.1
New Function:
Two new Report Object functions added that support the creation of "Report Blocks".
   • setStartRow()
   • setBlockSize()
Fixes:
Charts were not being rendered for some license configurations based on subdomains.
QLR Manager now checks for the existence of PHP GD support prior to attempting to create a chart, thus avoiding a fatal error.
Apr 23, 2005 3.1
New Function:
PostgreSQL support added.
A zero column width Layout setting will now hide columns, but still allow for column actions to be performed.
Break level data can now be accessed for display using &b(x) column referencing. This can be used in conjunction with zero width columns.
Titles, footers and break text can now contain calculations using eval([formula]). These calculations can contain column references.
The export of queries, layouts, etc... added to qlradmin.html. This allows for the transfer of data between QLR instances, such as test and production systems.
A complete version of the User's Guide is now available in PDF format.
Fixes:
Allow for charts to be viewed as part of a report object when the getStyledReport() report object function is called.
QLR Manager now checks for the existence of PHP GD support prior to attempting to create a chart, thus avoiding a fatal error.
Feb 24, 2005 3.0
New Function:
Chart creation added to the Enterprise Edition. Five chart styles with over 25 variations and 40 chart characteristics that can be control via the layout panel.
MS Excel file creation added to the report output options.
Two new Column Actions were added to the layout panel: Accumulative Summing (Cum Sum) and Percent of Total (% of total).
Each User ID can save their layout preferences (fonts, colors, break characteristics, column actions, etc.) as their layout defaults. This allows for intricate Report Layouts to be recreated with little effort.
QLR Color Selector introduced. The selector provides the ability to choose from over 60 predefined, web-safe colors or mix from the RGB pallet of 16 million colors. The selector is available for all elements requiring a color selection.
Improved control over report appearances. The user is able to modify the size and color of the borders used in reports, including the outer, inner, and header borders.
HTML output files can be loaded directly into MS Excel and maintain their font and color attributes.
Expanded output options for macro e-mails added. In addition to the standard in-line report formats, chart images are sent as attachments. Report content can also be sent as Comma Separated Value (CSV), MS Excel or HTML attachment files.
Fixes:
Ampersands (&) are now handled correctly in the query text area.
The border and background color formatting for empty cells in a report is now preserved when reports are forwarded via e-mail.
Dec 11, 2004 2.1.4
New Function:
Two new query variables have been added (**qlr_dmy and **qlr_mdy) to support date input formats of dd/mm/yyyy and mm/dd/yyyy.
It is now possible to suppress the sending of e-mailed reports in a Macro step when the report query results in 0 rows of data. This is done by adding >0 (greater than zero) to the beginning of the e-mail recipient list in the Macro step.
Nov 19, 2004 2.1.3
Fixes:
Page row counting now accounts for rows of 'Text before the Break' properly.
Nov 17, 2004 2.1.2
Fixes:
Fixes page size overrun when a break is encountered at the bottom of the page. This sometimes caused unwanted page breaks when printing.
Nov 7, 2004 2.1.1
Fixes:
CSV file data was appearing in the Report Tools window for latest release of Internet Explorer, instead of being treated as a download file.
Oct 30, 2004 2.1
New Function:
Report Objects added to Enterprise Edition. Allows users to embed reports into PHP generated web pages.
Added option to connect directly to the User Menu panel at logon, bypassing the Query panel.
Oct 7, 2004 2.0.2
Fixes:
Objects being saved with the same name, but different case (upper or lower), were not being handled properly.
Oct 1, 2004 2.0.1
Fixes:
Addressed problems introduced by the new browser security model in Microsoft XP service Pack 2.
Sep 15, 2004 2.0
New Function:
Macros are available in the Small Business and Enterprise editions. A Macro allows for the defining and executing of saved queries (and optionally, Layouts) in a sequence of steps. In addition to viewing the output, the results of each step can be e-mailed to a separate set of recipients if desired.
Menus are available in the Small Business and Enterprise editions. A Menu is a user defined set of saved queries and/or macros. Other menus can also be referenced in a menu. In the Enterprise edition, users can be limited to using just menus to execute stored queries and macros.
A user's saved queries and macros are automatically placed into a menu called *My_Menu*.
QLR Manager can now be run on a client browser that has been configured to reject cookies.
Multiple SELECT queries can be run in a single query batch. Although a layout cannot be applied to the resulting reports, this allows for a quick look at data from multiple tables at one time.
A query variable, called "**qlr_userid", has been added. This is a dynamic variable that returns the logon ID of the current user. This allows for the authoring of queries to return results based on the user who is running the query.
May 7, 2004 1.1
New Function:
Query variables can now be added to a query. When found, the user is prompted to supply input values for the variables.
A user ID can be set up with "Read Only" access to queries, limiting them to running the query as is without the ability to alter the query.
The Enterprise edition allows the administrator to control, via the user profile, whether a user can edit a query, share a query or layout, or retrieve shared queries and layouts.
The help system has been enhanced, offering expandable and collapsible sections in the left navigation bar, and a find function has been added for IE and Netscape/Mozilla browsers.
Improved formatting of reports when printing from the browser.
Fixes:
Problems with controlling the number of objects a user ID could save in an Oracle installation have been fixed.
Report e-mails sent to some mail services would result in a Javascript error.