| Date |
Version |
Description |
| 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: |
| • |
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 |
| Fix: |
| • |
Page row counting now accounts for rows of 'Text before the Break' properly.
|
|
| Nov 17, 2004 |
2.1.2 |
| Fix: |
| • |
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 |
| Fix: |
| • |
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 |
| Fix: |
| • |
Objects being saved with the same name, but different case (upper or lower), were not being
handled properly. |
|
| Oct 1, 2004 |
2.0.1 |
| Fix: |
| • |
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. |
|