PVRQ Report/Query Writer Version 1.16 Release Notes Changes included in this release: 1. On the column options screen, changed the "data size" entry to allow an expression. This is useful for data that may have a variable size by installation. 2. The "longwinded description" of the data dictionary element will now be examined for the string "Size=%". If found, the data element size will be set to the value of the global variable that follows the "Size=". The global variable must be non-zero or this will be ignored. 3. Added report variables PVRQ_LINE and PVRQ_ALL_LINE to facilitate numbering the lines on the report. To print a line number on each detail line, define a numeric formula as PVRQ_LINE++ or PVRQ_ALL_LINE++. PVRQ_LINE gets reset to one at each subtotal break; PVRQ_ALL_LINE does not. 4. Added an option to the column definitions screen to print ONLY the totals for the column, hiding the detail for just that column. This option is ignored when printing to Excel or to a delimited file, or when the report is printed in summary format. 5. Enhanced the linked table feature so an exact key match is not required. If the key specified is not found in the linked table, then the key is treated as a partial key. The next key in the linked table is obtained and compared with the desired partial key. If this next key matches the partial key, the linked record is returned to PVRQ. 6. In conjunction with the partial key option when linking tables, added an option to return multiple records. If this option is selected and multiple records match the partial key specified, all of those records will be printed (subject to your filter). If the option is not selected and multiple records match the partial key specified, only the first record will be returned. 7. Corrected a problem where the table link was not using the alternate keyset when specified (it was always using keyset 0). 8. Added an option on the configuration screen to select the font to be used for reports printed to a Windows printer or the ProvideX Viewer. The recommended font is Courier New. Keep in mind some fonts do not scale well. If you choose a font other than Courier New and your reports no longer print as expected, choose a different font or use Courier New.