Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Reports and Labels > Report Designer

Menu Bar

Scroll Prev Top Next More

Database

 

Connect... - prompts to connect to a database

Disconnect - disconnects from the currently connected database

Connection history - provides a history of previously connected databases

Exit R:BASE - exits R:BASE

 

File

 

New... - creates a new report

Open... - opens an existing report

Save - saves the current report

Save As... - saves the current report as a new report

Page Setup... - opens the Page Setup dialog for changing page specific settings

Print - prints the report to the default printer

Print to - prints the report to an output option within the list

Print to Text File Setup... - opens the Print to File Setup dialog for changing settings specific to printing to a text file

Close - closes the Report Designer

 

Edit

 

Undo - restores the last change on the report

Cut - cuts the current selected text or object(s)

Copy - copies the current selected text or object(s)

Paste - pastes the contents of the clipboard

Delete - deletes the current selected object(s)

Find in Custom EEPs... - opens a Find in Custom EEPs search utility to locate specific text within all Custom EEPs

Select All - selects all the objects on the report

Bring to Front - sets the currently selected object to the foreground if object is part of a layer

Send to Back - sets the currently selected object to the background if object is part of a layer

 

View

 

Toolbars - toggles the display of Report Designer toolbars

Rulers - toggles the ruler feature for aligning objects

Grid Options... - opens the Grid Options dialog for adjusting grid pixel dimension and Snap to Grid features

Show Data - displays actual table data during design time rather than the object label

Favorites... - allows users to customize favorite controls onto a single toolbar for commonly used items

Control List - displays the list of available controls to add an object to the report

Scrapbook... - opens the Scrapbook utility, which acts as repository for created and commonly used objects

Switch Between Design/Code - toggles between the "Design" and "Code" tabs

 

Tables

 

Add/Remove Tables - allows users to add and remove tables

 

Report

 

Report Header - toggles the display of the Report Header band

Report Footer - toggles the display of the Report Footer band

Page Header - toggles the display of the Page Header band

Page Footer - toggles the display of the Page Footer band

Page Style - toggles the display of the Page Style band

Breaks... - opens the Breaks dialog for configuring report breakpoints

Portrait - sets the report orientation to the portrait format

Landscape - sets the report orientation to the landscape format

Cache Pages - toggles page caching, which helps report previews to finish more quickly if the report will be previewed frequently. This option may have undesired effects when making design time changes and trying to view them, so please be aware of your current setting.

Pass Setting - sets the report engine to process system variables once or twice. The value of the Pass Setting property determines how many times a report traverses the data before generating pages.

Disable Trace - toggles the ability for the Trace Debugger to launch when running the report. This feature adds additional security to your report by not allowing users to view the command syntax.

PDF Controls Tab Order... - specifies the tab order for the PDF output, for the defined PDF Form Controls

Units - sets the display units of the ruler

Actions - specifies a procedure to run

Document Custom EEPs - generates Custom EEP documentation to the clipboard, printer, text file, PDF file, the R:BASE text editor, or launches the EEP Map

Passwords - protects reports with security, separate from the User Privileges

Set Design Password - specifies a design password to protect access to the report in the designer. Once the design password is set, R:BASE will prompt for a password the next time the report is opened in the designer.

Set Print Password - specifies a print password. When printing the report, the end-user will be required to enter a password.

Preview WHERE Clause - allows a WHERE Clause to be entered and applied to the preview results

 

Variables

 

Add/Edit Variables... - presents the Expression Builder for adding and editing existing variables defined for the report

List of Expressions... - provides a comprehensive output of all the currently defined variables within the report

Clear Variables After Printing - toggles whether or not the variables defined within the report will be cleared after the printing action has completed or if they will be left as global variables

 

Tools

 

Add/Remove Watch Variables - presents the Watch Variable dialog for you to select variable values to monitor

Show/Hide Watch Variable List - toggles the display of the Watch Variable List, which remains visible during processing

Data Dictionary - displays the Data Dictionary for finding database information

BLOB Editor - displays the BLOB Editor to create and edit binary files

Scratch Pad - displays a scratch pad window to hold any text that is frequently used or wanted to use as a reference during development

R> Prompt... - opens the R> Prompt window

Database Explorer - opens the Database Explorer

R:BASE Editor - opens the R:BASE text editor

Browse/Edit Table - presents the Data Browser for viewing data within a table or view

Query by Example... - opens the Query Builder to query table data

File Explorer - opens the Windows Explorer for navigating to and opening files

Launch... - launches a file based on its existing file association

Database Connections - displays the current number of connections to the database, with the option to reset the user count

 

Settings

 

Startup Options... - customizes how R:BASE starts

Database Explorer - changes the appearance and behavior of the Database Explorer

R:BASE Editor... - customizes the R:BASE Editor

R> Prompt... - change the appearance of the R> Prompt

Data Browser... - change the font and colors within the Data Browser

Data Designer

Relational Verification - verifies the table's relation integrity. If checked, the relational verification of data type for matching column name will be validated while in the Data Designer, not when the table is saved. The default is set to OFF. If unchecked, the relational verification will be performed when saving the table.

Warn When in Multi-User Environment - displays a warning when the Data Designer is launched and other users are connected to the database

Column Name Template - provides a default value when adding new columns to tables

Form Designer... - customizes the Form Designer Default Settings

Report/Label Designer - customizes the Report/Label Designers Default Settings, as well as the Report Email Settings

Application Designer - Create Backup Copy - creates a backup copy of an R:BASE application file (.rba), using the .rb~ file extension

BLOB Editor... - alters the BLOB Editor default settings

Hint Settings... - set the default settings for all pop up hints

Walkmenu Time Interval... - sets the WALKMENU time interval for keystrokes

Default Printer Font... - provides the default font for printing

ROSK Settings... - provides settings for the R:BASE On-Screen Keyboard

Input Language... - specifies the keyboard input language

Custom Colors - allows users to save and load custom colors from one development computer to another

Registry Settings - allows users to save and load custom R:BASE environment settings from one development computer to another

Warn When Closing R:BASE Session - displays a warning when closing the R:BASE session

Show Check Box to Suppress Error Messages - places a check box in all error message windows allowing you to suppress the error message(s). After selecting to suppress the error messages, you will not see any error messages within the entire R:BASE environment. In order for error messages to be displayed again, you must restart R:BASE or issue the "SET ERROR MESSAGES ON" command.

Clean Scratch Files on Exit - deletes any remaining temporary scratch files (.$$$) after R:BASE closes

Show Comments in Table/Field List - displays comments/descriptions with property editors and table listing dialogs

Configuration Settings... - alters the settings stored in the R:BASE configuration file

 

Utilities

 

Integrity Check - performs an integrity check for the connected database, using AUTOCHK

Reload... - reloads and builds the database to a new name, using RELOAD

Pack in Place - recovers unused disk space for the schema, keys, or all within the database, using PACK

Pack Passwords - recovers unused disk space for the system passwords, using PACK

Pack Index - recovers unused disk space for database indexes, using PACK

R:Backup - launches the R:Backup database backup utility

XML To Data Packet - prepares a data packet file from an XML file, by selecting the node containing the data/rows, for importing into R:BASE

Connect SQL Data Source... - connects to an ODBC data sources via a DSN

Disconnect SQL Data Source... - disconnect any currently connected SQL Data Source

Attach SQL Database Tables - attaches tables from currently connected SQL Data Sources

Detach SQL Database Tables - detaches tables from currently connected SQL Data Sources

Convert Extended ASCII In Objects To UTF-8... - converts database and application projects that use extended ASCII characters

Take a Snapshot - takes a screen shot of the R:BASE window or current screen to paste into another program

Set Working Directory... - sets the current working directory

Plugins - displays the installed R:BASE Plugin modules

Map Network Drive... - maps a network drive

Disconnect Network Drive... - disconnects a currently connected network drive

Add Printer... - presents the Windows "Add Printer" dialog for adding a new printer

Find in Files... - opens the built-in Find in Files search utility for finding text within files

Database Versions... - scans the provided folder for databases, and lists the file, path, and version information

Run... - prompts for the location and file name of the program you want to run

Magnifying Glass - displays a Magnifying Glass lens that produces a zoomed display of the R:BASE environment

On-Screen Keyboard - displays the R:BASE On-Screen Keyboard (ROSK)

Set User ID and Password - prompts to enter a user identifier and password

User Privileges... - displays options to grant and revoke privileges to users

 

Window

 

Cascade - cascades the current window group

Tile Horizontal - horizontally tiles the current window group

Tile Vertical - vertically tiles the current window group

Minimize All - minimizes the current window group

MDI Windows - displays the list of opened MDI windows

 

Help

 

Table of Contents - displays the R:BASE in-line help documentation

Help Index - provides an index keyword search of the help

Help Search - provides a word search of the help

R:BASE Tutorial - opens the R:BASE Tutorial

R:BASE Home Page - opens the R:BASE Technologies, Inc. home page

Product Registration... - opens the product registration web page

Product Activation - displays specific software information, such as registration number, seat count, license key, and activation key

Check for Updates - opens the product updates web page

R:DCC Client - opens the online database for users to submit and track reported bugs and enhancements requests for R:BASE

Show License - displays the R:BASE license agreement

File Versions... - displays a list of files that are opened by R:BASE, including operating system dynamic link libraries and R:BASE plugins

About R:BASE - displays the R:BASE version and build