RSW81026.TXT
README file for R&R Report Writer for SQL
Version 8.1.026 Service Pack Update

This service pack includes a number of fixes to RSW Version 8.1.

FILE CONTENTS OF THIS SERVICE PACK (RSW81026.ZIP)
RRCNVRT.EXE	DATED 08/09/2000
RSW.EXE		DATED 08/25/2000
RSW.HLP		DATED 07/16/2000
RSW80126.TXT	DATED 09/04/2000
RSWDEV.HLP	DATED 07/15/2000
RSWRUN.EXE	DATED 08/08/2000


INSTALLATION INSTRUCTIONS
After downloading file RSW81026.ZIP, open it and then extract the contents to your R&R 
SQL program directory replacing the existing copies of these files.  
DO NOT install this service pack if you have not installed R&R SQL Version 8.1.


FIXES INCLUDED IN THIS UPDATE
                                                                                  
-Fixed Export to DBF so only fields in band get exported.
-Added support to allow use of a default database rather that the one saved report.
 To enable this feature,
 edit RSW.INI to include:
 [Database]
 USEDEFAULTDATABASE=1

-Fixed crash problem running reports that require login to a datasource from 
 Shortcut Maker/Runtime.

-Changed icon for rrcnvrt.exe.

-Changed title lines in print report specification.
-Added "Comment: " to total/calc fields in report specification.
-Added "Total: " and "Formula: " to report specification.

-Help files updated.


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 at
telephone:	800-325-9035
email:		livesupport@livewarepub.com