RRW81026.TXT README file for R&R Report Writer for Xbase Version 8.1.026 Service Pack Update This service pack includes a number of fixes to RRW Version 8.1. FILE CONTENTS OF THIS SERVICE PACK (RRW81026.ZIP) RRW.EXE dated 09/28/2000 RRW.HLP dated 07/06/2000 RRW32.OCX dated 07/20/2000 RRW81026.TXT dated 09/04/2000 RRWICON.EXE dated 07/14/2000 RRWIZ.EXE dated 07/14/2000 RRWRUN.EXE dated 09/28/2000 INSTALLATION INSTRUCTIONS After downloading the file RRW81026.ZIP, open it and then extract it's contents to your R&R Xbase program directory replacing the existing copies of these files. Finally move the file RRW32.ocx to your Windows System directory. DO NOT install this service pack if you have not installed R&R Xbase Version 8.1. FIXES INCLUDED IN THIS UPDATE --Result set browser/Export-- -Fixed Export Result Set bug where lines on report layout would disappear after closing result set window. -Fixed Result Set Browser bug with other exports. -Fixed result set browser exporting unused field. -Fixed Export DBF so only fields in band get exported. -Added fields from sorting levels, grouping levels, query, calculated fields, total fields and line logic fields to Result Set Browser window. --Database support-- -Added support for dBase v7.5 files/indexes. -Fixed problem with MDX support of long index tag names. -Fixed bug where DBC master file replaced by DBF master file caused crash on report re-open. -No longer allows selection of *.dbc for related files --Report Specifications-- -Always print alias for print report specification. -Added "Comment: " to total/calc fields in report specification. -Added "Total: " and "Formula: " to report specification. --Other-- -Fixed Wizard problem that would cause extra lines in report. -Fixed F7-Move bug so that fields can be correctly positioned in all directions using keyboard. -Fixed OCX control for master index property so that master index can be modified via OCX. -Fixed rrwicon.exe to replace "Arpeggio" with "R&R Xbase". -Fixed help topic Property/Export in rrw.hlp. -Fixed some minor spellings in status bar on Designer. ADDITIONAL INFORMATION ABOUT "RESULT SET BROWSER" The current release of the Result Set Browser (RSB) tool has some special capabilities that will allow Report Designer users to "drill-down" through the data file R&R uses to build the report. There are also some special aspects to the control of the Result Set Browser that are related to this ability. 1) Control of records - The RSB window will contain the records that correspond to the band selected from the "Export" menu option, "xBase" export type. For example, if one selects the "Record" band in this dialog box (the default choice), R&R will fill the RSB window with every record in the composite database. If, however, one selects the "Summary" band, the RSB window will contain just the LAST record of the composite database, which would always include the full value for grand totals. Selection of one of the group footer bands will present the last record of each group, with full group totals, grouping values and other field values as of that last record. 2) Selected RSB band within layout - For the RSB window to contain ANY records, the band selected for export must have at least one line for the corresponding band in the layout. If one is not present in the layout, simply add one for the band selected. The record band can be suppressed using the icon on the formatting icon bar; other bands can be suppressed with line logic, or just left blank for spacing. In future releases, we will add a dialog box to execute upon select of RSB to select the band for placement in the RSB window. RSB has several advantages over other methods of "drill-down": 1) ALL data fields in the report are included at all levels. 2) The definition of fields is automatic; no separate drill-down definition is required. 3) The RSB window allows you to shift the position of the columns at will, placing key fields next to each other based on a variety of contexts. 4) The RSB window can remain open while other activities are performed in R&R. The window can also be sized and placed adjacent to the R&R Report Designer window or the Print Preview window. 5) You can save the contents of the Result Set Browser to either a DBF database or to an XL5 Excel worksheet. SUPPORT If you have any questions regarding this update, please contact: Liveware Technical Support telephone: 800-325-9035 email: livesupport@livewarepub.com