The Distribution dialog box specifies multiple destinations for report or section output and deletes destinations from the Distribution List.
Note: To display the Distribution dialog box: In the report or section Property Inspector, under the Report node, click the Distribution property value field.
This dialog box contains:
Distribution List |
Lists the destinations in the distribution list for the current report or section. |
|
Distribution ID |
Is an identifier for a destination. |
|
DESNAME | Is the name of the path and file, printer, or e-mail ID (or distribution list) to which the report output will be sent. Note: If you specify a file, the directories in the path must already exist. |
|
|
Default |
For the entire report For the main section For the header section For the trailer section |
DESFORMAT | Is the destination format, or the printer driver to be used when DESTYPE is FILE. |
|
|
Values |
|
|
BITMAP |
Specifies bitmap format as displayed in the Reports Builder user interface, which can be sent to a printer. |
|
Specifies HTML format, which can be read by an HTML 3.0 compliant browser. |
|
|
Specifies HTML format, which can be read by an HTML 3.0 compliant browser that supports Cascading Style Sheets. |
|
|
Specifies PDF format, which can be read by a PDF viewer. PDF output is based upon the currently configured printer for your system. The drivers for the currently selected printer is used to produce the output; you must have a printer configured for the machine on which you are running the report. |
|
|
Specifies character (ASCII) format, which can be sent to any Internet standard protocol SMTP e-mail system. |
|
|
Specifies RTF format, which can be read by standard word processors (such as Microsoft Word). |
|
XML | Specifies XML format, which can read by an XML-supporting browser, or your choice of XML viewing application. | |
DELIMITEDDATA | Specifies a delimited format that uses a known delimiter, such as a comma or a semicolon, which can be read by standard spreadsheet utilities, such as Microsoft Excel. The default delimiter is a TAB. | |
DESTYPE | Is the type of destination device that will receive the report output. |
|
|
Values |
|
|
File |
Specifies a file (named by DESNAME). |
|
|
Specifies e-mail (IDs identified by DESNAME). You can send e-mail to any Internet standard protocol SMTP e-mail system. The report is sent as an attached file. |
|
Printer |
Specifies a printer (named by DESNAME). |
COPIES |
Is the number of copies to distribute. |
|
New |
Adds the distribution definition in the Settings section to the Distribution List and opens a new line for a new distribution definition. |
|
Remove |
Removes the selected distribution definition from the Distribution List. |
|
Remove all |
Clears the Distribution List. |
In addition to normal file names, you can use DESNAME to define destination names for any of the three sections of a report (header, body, trailer) using the following syntax:
filename&<group_name>.ext
where group_name
is the report level group on which to repeat for the section and ext
is any valid filetype when DESTYPE
is set to File.
For example, report&<deptno>.pdf
generates several PDF
files, one for each department, provided the Repeat
On property is set to G_DEPTNO
on that section.
Note: The parent frame of the deptno
field must be deleted to get the desired data in each output file. Otherwise,
you will get the data of all departments in each output file.
The result of a distribution run will be files named:
report10.pdf
- containing information for employees belonging
to department 10
report20.pdf
- containing information for employees belonging
to department 20
report30.pdf
- containing information for employees belonging to department 30 and
so on.
You can only distribute reports to multiple destinations in bitmap or character mode, not a combination of both.
You must set the MODE
system parameter
to CHARACTER
to distribute reports in ASCII.
About report sectioning and sections
Distributing a report to multiple destinations
Copyright © 1984, 2005, Oracle. All rights reserved.