PVRQ Report/Query Writer Version 1.14 Release Notes Changes included in this release: 1. When printing a string field, if the length of the string in the database is longer than what is specified for the report, the string will be truncated to the desired size. 2. Added the ability to page break after printing subtotals. 3. Corrected a problem where subtotals were printing out of sequence when three or more subtotal breaks were specified. 4. Added the ability to specify a report header and footer to print on each page. 5. Added the ability to link to a table using elements from another linked table. Since linked tables are read in alphabetical order by the Link ID, this new feature will only work when the Link ID is alphabetically higher than the Link ID of the table these elements are coming from. PVRQ will check your table link entry to make sure the link will be successful. It will look for elements you specify in the Key Definition to see if they come from another linked table, and if they do, the program will compare the Link ID of the table these elements come from with the Link ID of the new table you are linking. It will advise you if need to select a higher Link ID. 6. Changed the report filter option to allow filtering on elements from linked tables. 7. Changed the custom sort option to allow sorting on elements from linked tables. 8. Added MAS90 date handling. MAS90 dates are identified by the presence of DATE*MAS90 in the data class in the data dictionary. The user may manually tell PVRQ the data is as MAS90 date on the column options screen. 9. Improved the print masking option for string data. 10. Improved the graphical appearance of reports printed on Windows printers or to the ProvideX viewer. 11. Improved the positioning of column titles, so they are centered in the column. 12. Added the ability to use ProvideX sort files defined in the data dictionary. 13. Added the ability to invoke PVRQ and run only a specified report, then exit. To do this, set the global variable %PVRQ_RUNREPORT$ to the report you wish to run, then run PVRQ. The selected report will be printed if it is on file, and the user has sufficient security clearance for the tables that report accesses. PVRQ will set %PVRQ_RUNREPORT$ to null prior to exiting. This new feature will allow developers to set up a menu of predefined reports for their users to run without having to select a report within PVRQ. 14. Improved the handling formula definition errors. Errors used to force the user to correct the formula definition without the ability to cancel or change the data type. 15. For numeric data elements that don't have a print mask in the data dictionary, a default print mask will now be provided automatically. 16. If a message library is active, the column titles of the report will be translated when the report is run. If the translated text exceeds the width of the column, it will be truncated. To disable the use of the message library, set the global variable %PVRQ_NOMSGLIB to 1 before running PVRQ.