What's New in R&R Version 11

Password Protection

You can now optionally set a Designer and/or a Runtime password for a report using the menu selection File->Security.

 This password may be up to 30 characters in length. Passwords are case-sensitive and may include spaces and special characters. When you enter a password, your input is masked on the display.

When a password(s) has been set in File Security, when the report is save (via Save or Save As) you will be asked to Verify the password(s) by re-entering it. The report will not be saved unless the password(s) correctly matches the password(s) that was set in File Security.

When you open a report in the report designer or at runtime that has a password, you will be given a screen to enter to the password. This password must match the password that is saved in the report or you will not be able to open or run the report.

 CAUTION:

Once a report is saved with a password, it can only be opened if that password is correctly entered.

There is no facility available to recover a lost password.

If you set a password for a report, it is strongly suggested that you print your Report Specifications before saving the report and keep this information in a secure place. Any Designer or Runtime password will be printing in the header area of the report specification. You will then have a record of the password(s) that has been set for the report.

Note that password information is NOT saved to the Report Librarian.

Reports with a saved password cannot be converted to any other format using the ReportWorks Report Converter.

Auto Recovery

A new Auto Save item has been added to Options->Preferences. 

You can now check a box to enable R&R to automatically save changes to a backup copy of the report are working on every 1-120 minutes. When auto recovery is enabled, R&R saves a copy of the current report in the same directory as the original at the designated interval.  It also writes the name of the save file in the RRW.INI file. Should there be a problem causing R&R closes unexpectedly, the next time that you open the Report Designer, you will be asked if you want to open the auto saved file. This file will contain all of the changes to the file that was open in your last designer session up to the last recovery point.

 Enhanced Ruler Display

We have added the ability to display the horizontal and vertical positioning rulers at the top and the right of the layout screen. Selecting View->Rulers now brings you to a tabbed ruler dialog where you can use a checkbox to optionally display of each of the four available rulers.

 Multiple Field Alignment

You can select multiple fields on the report layout and then use the menu command Format->Align to align all of the selected objects to have the same selected placement as last selected object.

 For example you could select 3 fields on 3 separate band lines and then choose Format->Align Left to move the first two selected objects to have the same left edge as the last selected object.

No Records Found Band Line

In previous versions of R&R, there was not a way in the report designer to produce output when no records were found for the report.  We have added a new No records found checkbox that it available for Title band lines.   

When this box is checked, the title band will print both in the designer and at runtime only when no records are found.  This allows you place appropriate text on a no records found line that will allow you to produce a report even when no records are found.

In runtime, the older behavior of always printing the title and summary when no records are found, required the creation of conditional calculations to return specific output for a no records found condition. The new method is a much simpler approach.

To allow reports created in earlier versions to use the older behavior, a new setting is available in the [Defaults] section of RRW.INI.

If the INI contains the line:

NoRecHDR=0

Runtime will print all title and summary bands when no records are found (the old default) rather than only those title bands with a No records found checkbox.

The new behavior will be used if NoRecHDR is set to 1 or is absent from the INI.

The new version continues to honor the  /H switch on the runtime command line.

If a /H is used, there will be no report output at runtime when no records are found. Any title band having a no records enabled, will not print.

Enhanced Undo and Redo

The range of report layout actions that can be reversed using Edit->Undo has been expanded from moving or removing an object or band line to include:

o   Inserting any object on the layout

o   Inserting any band line

o   Any Font/Size/Attribute changes

o   Resizing of objects on layout

 We have also added an Edit->Redo to the menu as well as adding Undo and Redo buttons to the Standard toolbar.  Clicking on these buttons will display a list of the most recent actions that can be changed.  When you undo an action, you also undo all actions above it in the list.

If you later decide you did not want to Undo an action you can use the Redo button to reverse it.

 

Enhanced Field Lists

Field list dialogs have been changed to a more descriptive columnar format.

 What is displayed

The Name column includes both the field name and any optional comment or dictionary description.

The table column shows the field’s table alias.

The type column shows the field’s data type.

The class column shows the field’s usage class.

An asterisk * before a field name indicates that the field is currently used on the report layout.

Right clicking on a field displays any available dictionary information.

Customizing the list

Clicking on a column heading sorts the list by that column and adds a sort direction indicator.

Clicking on a sorted column heading again reverses the sort order.

Clicking on a column header separator bar allows you to resize a column.

 Filtering the list

The Go to Field box allows you to enter one or more characters to limit the field list to display only field names beginning with the characters you have entered. Press backspace to clear the box and display all fields.

 

Longer Computed Field Names

The maximum length for computed field names in R&R has been extended from 10 to 30 characters.

 

Find and Replace in Expressions

A new Replace button is now available with calculated expression dialogs.

 This new dialog allows you to quickly edit calculated expressions containing repeated values.  For example a calculated expression:

(Q1_2004+ Q2_2004+Q3_2004+Q4_2004)*Disc2004

 could use a single replacement string (Replace 2004  with 2005) and become the 2005 calculation:

 (Q1_2005+ Q2_2005+Q3_2005+Q4_2005)*Disc2005

 

Total field enhancements

Dialog changes

The total field and auto total dialogs have been changed to use a tabbed format. Each tab now provides more instructive information and detailed help on each component of total creation.

 Multi Edit

We have also added a new Multi Edit button to the Total Fields dialog.  Multi Edit allows you to select several total fields and then make the same edit changes to each one.  For example you could select a Group1, Group2 and Grand Total that sum the numeric field QTYSOLD and change the sum to be an average.

 Updated ParameteRR Dialog

The dialogs for creating parameters within the designer and for entering values at runtime have been updated.

Static ParameteRR Lists

ParameteRR fields now support the definition of list values so that one or more pre-defined values may be selected when a report is run.

A parameteRR can be defined within the designer to use a static list of defined values and a short description can be entered for each one.  List parameteRRs can be of character, numeric, date or date time data type. 

Updated Export

The Export dialog has been changed to a tabbed format with separate tabs for Type, Mail Options and Export Options.

 In Mail Options the Subject and Message fields now can be selected from a field list rather than manually entered. This is particularly useful for email bursting where each email message can now be completely customized for each recipient.

Duplicate Field Export Warning

If the first 10 characters of two field names on a band line that is being exported to a DBF or viewed as a Result Set are the same, a new warning message is issued.  In previous versions, the duplicate field was simply omitted without any warning.

Updated Charting Support

We have updated the graphics support library routines that are used for creating charts in R&R from Version 5 to the latest 6.2 Graphics Server release.

 

 

Top

Top