WebFOCUS
Online Help > Managed Reporting Developer > Creating Reporting Objects > Customizing a Join in Developer Studio
Customizing a Join in Developer Studio
In this section: How to: Reference: |
You can customize an existing Join by changing the files
or fields involved. If no default Join was created, you can use
the same technique to specify a connection explicitly.
You can also change the Join name, create single instance (unique)
joins, use a virtual field as the Join field, and add tag names
to the Join files.
Procedure: How to Remove a File From the Join in Developer Studio
-
Click
on the Fields window of the file you want
to remove.
-
Click
the Delete button on the toolbar or press the Delete key
on your keyboard.
If you
delete the host file, all cross-referenced files are automatically deleted.
Procedure: How to Delete a Join in Developer Studio
-
Right-click
the Join connector line.
-
Select Delete from
the shortcut menu.
You can
also select the Join connector line and click the Delete button
on the toolbar.
The files remain in the window with no connector
line between them.
Procedure: How to Specify Join Fields in Developer Studio
To create
your own Join (after deleting the existing Join, if necessary):
-
Select
a field in the host file pane.
-
Click
and hold the selected field.
-
Drag
the selected field from the host file pane onto the matching field located
in the cross-referenced file pane.
-
Release
the mouse button.
A Join
connector line appears.
Reference: Usage Notes for Specifying Join Fields in Developer Studio
- You can multi-select
fields in the host file to join to a single field in the cross-referenced
file when both are FOCUS files. For other file types (for example,
EDA, Oracle, DB2, and so on) you must join a host field to a cross-referenced
field, one pair at a time.
- For non-FOCUS
joins, you can join a maximum of 63 fields from each file.
Procedure: How to Create Additional Joins in Developer Studio
You
can leave the Join editor window open and create another Join by:
- Clicking the New
Join button.
or
- Choosing New
Join from the File menu.
You can
define up to 63 concurrent Joins.
Procedure: How to Create a Single Instance (Unique) Join in Developer Studio
By default,
each Join has multiple instances (that is, is non-unique). To create
a single instance (unique) Join:
-
Right-click
the Join connector line.
-
From
the shortcut menu, select Single Instance.
Changing the Join Name in Developer Studio
A default name is automatically assigned to each Join.
You can use the Join name to later clear the Join and to prevent
another Join from overwriting it. If you remove the Join name completely,
any subsequent unnamed Join will overwrite this Join.
Procedure: How to Change or Remove the Default Join Name in Developer Studio
-
Right-click
the Join connector line and select Join
Name from the shortcut menu.
The Join Name dialog box displays the default Join name.
-
In the
Join Name box, edit or delete the name and click OK.
Note: The
following words cannot be used as a Join name: ALL, AND, AS, IN,
JOIN, TAG, TO, WITH.