Report menu
Run
Select Report--> Run to
run the report.
Properties
- Select a report at a server.
- Select Report--> Properties to
open the Report Properties window.
In this window, you can provide the following report information:
- General
- Formatting
- Output
- Procedure
- Variables
- Miscellaneous
- Schedule
- Security
- Global variables
Note:
The Formatting, Output, and Procedures tabs are
disabled for queries that do not use the SQL SELECT statement because
they do not return data (non-SELECT SQL verbs).
REPORT PROPERTIES - FAVORITES
A hidden menu with two options is
available from the Properties window. The menu becomes enabled when
you select a report from your Favorites folder, select Properties,
than right-click on any page in the Properties window.
REPORT PROPERTIES - GENERAL TAB
The
General page of the Report Properties window opens when you select Report--> Properties,
then click the General tab.
Table 53. General Options
Field |
Description |
Report name |
This field display report name information, such
as:
- The QMF object type followed by OBJECTOWNER.OBJECTNAME, such
as:
QUERY Q.STAFF
- the report description if the selected report is in your Favorites
folder
|
Server |
Type the name of the server on which the report
resides, or select a server from the drop-down list. |
Object type |
This field identifies the type of object with
which your are working. This can be a query, table, or procedure.
You cannot edit this field directly. To select another object, click Select to
open the Object Filter dialog box. |
View QMF Object text |
Check this check box to display the SQL for of
the QMF object. |
REPORT PROPERTIES - FORMATTING TAB
The
Formatting page of the Report Properties window opens when you select Report--> Properties,
then click the Formatting tab.
Note:
Select the No formatting (data only) radio
button to use Microsoft Excel, Lotus 1-2-3, or Microsoft Access
as the output application.
Table 54. Formatting Options
Field |
Description |
No formatting (data only) |
Select the No formatting radio
button to return raw data to the file |
Include column headers |
Check this check box to add labels to report
columns. |
Default QMF formatting |
Select this radio button to return data in the
default QMF format, which includes column headers and a horizontal line
to separate the headers and data. |
QMF formatting from form |
This field displays the form that will be used
for data formatting. |
Select form |
Click Select Form to open
the Form Filter dialog box to specify an object owner and object
name of the form to use for the report. The Select a Form dialog
box opens and lists the forms available to use for data formatting. |
Run |
Click Run to run the SQL |
REPORT PROPERTIES - OUTPUT TAB
The
Output page of the Report Properties window opens when you select Report--> Properties,
then click the Output tab.
Note:
Select the No formatting (data only) radio
button on the Formatting page of the Report
Properties window to use Microsoft Excel, Lotus 1-2-3, or Microsoft
Access as the output application.
Table 55. Output Options
Field |
Description |
Select output application |
Select or browse for the application for which you
want to format the report.
For Microsoft Excel, Lotus 1-2-3, and Microsoft Access applications
and the printer option, click Options to define
specific output options. |
|
MICROSOFT EXCEL
Select Microsoft Excel from the Select output application drop-down
list, then click Options. The Report Output
Options dialog box opens.
- Select or enter a sheet name
Select a sheet name from the drop-down list or type a new sheet
name in the text box for the Microsoft Excel worksheet.
- Use the QMF object name
Check this check box to use the object name as the report name.
- Append the above name with
Select the date format from the drop-down list to use as a suffix
for the report name.
- Include column names
Check this check box to display column headers in the formatted
report.
- Output range
Click the Output range text box to launch Microsoft
Excel. The Output range dialog box opens.
Click the cell in the spreadsheet where the results should be
written. The output range will be updated to the specified cell position.
Click Data Options to specify additional formatting
options for graphing and grouping data.
Note:
Data Options is disabled
if you selected Default QMF formatting or QMF formatting from
the Properties--> Formatting tab. |
|
LOTUS 1-2-3
Select
Lotus 1-2-3 from the Select output application drop-down
list, then click Options. The Report Output
Options dialog box opens.
- Select or enter a sheet name
Select a sheet name from the drop-down list or type a new name
in the text box for the Lotus 1-2-3 worksheet.
This option is not available if the Use the QMF object name check
box is checked.
- Use the QMF object name
Check this check box to use the object name as the report name.
- Append the above name with
Select the date format from the drop-down list to use as a suffix
for the report name.
- Include column names
Check this check box to display column headers in the formatted
report.
- Output range
Click the Output range text box to launch Lotus
1-2-3. The Output range dialog box opens.
Click the cell in the spreadsheet where the results should be
written. The output range will be updated to the specified cell position.
Click Data Options to specify additional formatting
options for graphing and grouping data.
Note:
Data Options is disabled if
you selected Default QMF formatting or QMF formatting from
the Properties--> Formatting tab. |
|
MICROSOFT ACCESS
Select
Microsoft Access from the Select output application drop-down
list, then click Options. The Report Output
Options dialog box opens.
- Select or enter a table name
Select a table name from the drop-down list or type a new name
in the text box for the Microsoft Access table.
This option is not available if the Use the QMF object name check
box is checked.
- Use the QMF object name
Check this check box to use the object name as the table name.
- Append the above name with
Select the date format from the drop-down list to use as a suffix
for the table name.
- Overwrite existing data in table
Check this check box to replace existing data in the named table
with data from the most recent report.
- Select or enter a report name (optional)
Optional: Select or enter a report name
to view a predefined Microsoft Access report when the database opens.
This option is useful when you want to view the report after
it runs.
Click Data Options to specify additional formatting
options for graphing and grouping data.
Note:
Data Options is disabled if
you selected Default QMF formatting or QMF formatting from
the Properties--> Formatting tab. |
|
PRINTER
- Select a printer
Select an installed printer from the drop-down list, or click Options to
select from other printers.
- Number of Copies
Type the number of copies of the report to print.
- Font Options
Select the font type and size for data in the report, or click Options to
choose other font options.
- Orientation
Select the Portrait radio button to print
the page with the short edge on top. Select the Landscape radio
button to print the page with the long edge at the top. |
|
- Page Width
Three options are available to control the width of the report
page:
- Fit to printer page: Select this radio button
to size the page width or length to fit the size of the printed
page.
- Characters: Select this radio button, then
type the number of character lines for the page size. The page size
will be restricted to this number of lines.
- Continuous: Select this radio button to print
continuous pages, without page breaks, or to wrap text for page
width
- Page Length
- Fit to printer page: Select this radio button
to size the page width or length to fit the size of the printed
page.
- Lines: Select this radio button, then type
the number of character lines for the page size. The page length
will be restricted to this number of lines.
- Continuous: Select this radio button to print
continuous pages without page breaks or wraps.
- Other Options
- Include date and time: Check this check
box to include a date and time stamp on the report.
- Include page number: Check this check
box to include a page number on the report.
- Margin (inches)
Set the top, bottom, left and right margins for the report by
using the up and down arrow keys or by typing the value in the input
field. Margins are measured in inches. |
REPORT PROPERTIES - PROCEDURE TAB
The Procedures page of the
Report Properties window opens when you select Report--> Properties,
then click the Procedure tab.
Table 56. Procedure Options
Field |
Description |
This procedure produces no output |
Check this check box to indicate that there is
no output, such as report results, produced from this procedure.
Instead, the procedure will run and a subsequent action will take
place. |
The procedure uses the DSQQW_PROC_OUTPUT substitution
variable |
Select this radio button if the procedure uses
the DSQQW_PROC_OUTPUT substitution variable. The variable is used
to export data to the location you specify in the output location. The
output location is passed to the procedure using this substitution
variable.
The syntax EXPORT REPORT TO &DSQQW_PROC_OUTPUT substitution variable
must be included in the procedure. Substitution variables will not
display in the Properties dialog box for the report. |
Publish to a temporary file, in the following
directory |
Select this radio button to specify the filename to
which the procedure will send output. |
Use the temporary directory of the machine
running this report |
Check this check box to use the machine's temporary
directory to save the report. |
Start file name with |
Optional: Type the prefix
for the file. This option is used with the Publish to a temporary file, in the following directory option. |
End file name with |
Optional: Select a date
format to use as a suffix for the file name.
Select RANDOM use assigned suffixes and avoid overwriting existing
report names.
This option is used with the Publish to a temporary file, in the following directory option. |
Extension |
Optional: Select one
of the following file formats to use for the temporary file:
|
Publish to a specific file |
Select this radio button to browse for a filename where
the report will be saved |
View output after running |
Check this check box to open the report after
it is produced. |
REPORT PROPERTIES - VARIABLES TAB
The
Variables page opens when you select Report--> Properties,
then click the Variables tab.
The Variable name field
lists the variables defined for the report.You can present values
for each variable.
- Type a value for the variable in the Variable value field.
- Optional: Select the Variable value field.
- Optional: Click List of values to
open the Variable Values List dialog box.
- Type a value for the variable in the text box at the top of
the dialog box.
- Click Add.
- Optional: Click Remove to
delete values from the variable values list.
- Optional: Click Move Up or Move Down to
resequence the values in the list.
- Optional: Click the User can type in their own values when the report is run check
box if the user can provide alternate values for the variable when
the report is run.
- Click OK.
The Variable value field is updated as
follows, indicating that multiple values have been defined for the
variable:
<List Value>
- Check the Hide this value check box to
hide the value of the variable when you run the report.
- Optional: Click Clear Values to
delete all values defined for the variables.
- Optional: Click Calculated date to
define which date to put on the report when you run the report or
schedule the report in the report scheduler.
This is similar to a date wizard. For example, you can use the
Calculated date function when you run a report on Mondays, but you
want to use the previous Friday's date on the report. The
Calculated date function will determine the correct date each time
you run the report, or pass in the correct date for a scheduled
report.
Note:
Use this feature only for queries that accept dates
as substitution values.
The Date Substitution Value dialog box opens.
Table 57. Date Substitution Values
Group box |
Description |
Task |
Notes |
Calculated date |
By days |
Select this radio button to specify the number
of days prior to the current date to use for the report date |
Type a number in the Number of days prior to current date field or
select a number from the drop-down list |
|
By days of the week |
Select this radio button to specify the day of
the week, whether in the current month, or the last month, to use
for the report. |
- Last occurrence in current month: Select
this radio button, then select a day to pass to the report, such
as the September 24, which is the last Tuesday of this month.
- First occurrence in current month: Select
this radio button, then select a day to pass to the report, such
as September 3, which is the first Tuesday of the current month.
- Last occurrence in previous month: Select
this radio button, then select a day to pass to the report, such
as August 26, which is the last Tuesday of the previous month.
- First occurrence in previous month: Select
this radio button, then select a day to pass to the report, such
as August 6, which is the first Tuesday of the previous month.
|
|
By month |
Select this radio button to specify the month
to use for the report, and whether to use the first day or last
day of the specified month on the report. |
Select By first day of month,
then select a number from the Month prior to current drop-down list
to calculate the date for the first day of the prior x number of
months.
For example, select the By first day of the month radio
button and type 6 in the Month prior to current field,
to print March 1 on a report if the current month is September.
For example, select the By last day of month radio
button and type 2 in the Month prior to current field,
to print July 31 on a report if the current month is September. |
|
By quarter |
Select this radio button to specify the quarter
and the day during that quarter to use on the report. |
- Select the By quarter radio button.
- Select the first, second, third or fourth quarter from the From beginning of drop-down
list.
- Select the first month of the fiscal year from the Fiscal year starts drop-down list.
|
Date format options |
Date format |
This field controls how the date will be formatted
on the report. |
Select the format in which to display the date
on the report from the Date format drop-down
list. |
|
Date separator |
This field defines the symbol used to separate
the elements of the date (year, month, and day). |
Select a date separator symbol from the Date separator drop-down list. |
|
Use PC date as current date |
Use the current date set on your PC |
Select the Use PC date as current date radio button
to use the date stored on the PC as the current date on the report. |
|
Use DB2 date as current date |
Use the current date set on the DB2 system (to
account for time zones) |
Select the Use DB2 date as current date radio
button to use the date from DB2 as the current date; this enables
users to use the correct date, based on their time zones |
Sample date |
Click View Sample to
see an example of how the date will display. |
|
|
Current PC date |
In the lower-right corner of the Date Substitution
Value dialog box, displays the current date you have set on your PC |
|
|
REPORT PROPERTIES - MISC TAB
The Miscellaneous page of the Report
Properties window opens when you select Report--> Properties,
then click the Miscellaneous tab.
Table 58. Miscellaneous Options
Field |
Description |
Run as a separate process |
Check this check box to run reports in a separate instance
of QMF Report Center, which allows you to continue working within
QMF Report Center. |
Suppress informational messages |
Check this check box to hide informational messages |
Suppress error messages |
Check this check box to hide error messages while
reports are running |
Limit the number of rows returned |
Type a number in this field to control the number
of rows returned to the report, which preserves system resources,
especially at peak times. |
Send an email message whenever I run the
report |
Check this check box to send an email notification
each time the report is run. |
Send an email message whenever the scheduler
runs a report |
Check this check box to send an email notification
each time the report is run through the report scheduler. |
Attach report output to the email |
Check this check box to include the report output
in the email notification.
Note:
For reports produced at the folder level, this option
will attach report output for all reports contained under the folder. |
Properties |
Click Properties to open
the Internet Mail Wizard where you provide addressing and routing
information for the email. |
REPORT PROPERTIES - SCHEDULE TAB
The Schedule page of the Report
Properties window opens when you select a query in the Favorites
folder, select Report--> Properties,
then click the Schedule tab.
Table 59. Schedule Options
Field |
Description |
Job ID |
This field displays the number of each scheduled
job. The number is assigned automatically and cannot be edited. |
Interval |
This field displays the frequency with which
the job is run, as specified in the Recurrence field. |
Days of week |
This field displays the day or days on which
the job is scheduled to run, as specified in the Days of week to run field.
Optionally, this field may be blank or contain <Customized> if the job has been edited using Microsoft's Task
Scheduler (R), indicating that QMF Report Center is not able to
display the job details. |
Days of month |
This field displays the calendar day of the month
on which the job is scheduled to run, as specified in the Days of month to run field. |
Time |
This field displays the time, in a 24-hour time format,
at which the job is scheduled to run on the specified days. |
Time |
Type the hour and minute at which to run the report,
using a 24-hour time format. |
Days of week to run |
Check the check box next to each day on which the
report is scheduled to run.
Optional: Check the Select all check
box to select all days of the week. |
Days of month to run |
Check the check box for the day or days during the
month when the job is scheduled to run.
Optional: Check the Select all check
box to select all days of the month. |
Recurrence |
- Today only
Select this radio button to run the job today only
- Once for the days marked
Select this radio button to run the job only once on the days
indicated in the Days of week to run or Days of month to run field
- Every time for the days marked
Select this radio button to run the job on the day or days selected
in the Days of week to run field or in the Days of month to run field |
Set Variable Values |
Click Set Variable Values to
open the Variable Input for Sched Job dialog box where you specify
variables to be used with the scheduled report. |
Edit Variable Values |
Click Edit Variable Values to
open the Variable Input for Scheduled Job dialog box where you can
modify the values for a variable.
Note:
Select the report name to activate this command
button. |
REPORT PROPERTIES - SECURITY TAB
The Security page of the Report
Properties window opens when you select the Public Favorites folder
and you select Report--> Properties,
then click the Security tab.
Use this page to define security information for users or groups
of users who can access objects in the Public Favorites folder.
Table 60. Security Options
Field |
Description |
User ID |
Select the name of the user or user group to which
you are assigning permission to the current object. Authorized users
and their permissions are displayed in the text box below. |
Add |
Click Add to add the selected
user, in the User ID field, to the authorized
users for the current object. |
Add All |
Click Add All to add all
of the users in the drop-down list to the authorized users for the
current object. |
Remove |
Click Remove to remove
the selected user or group of users from the authorized users. |
Permissions |
- Read
Check the Read check box to allow the user or
user group to view the current Public Favorites and run the objects
in it.
- Write
Check the Write check box to allow the
user or user group to modify properties of the current object and
add reports and folders if the selected item is a folder.
- Administer
Check the Administer check box to allow the
user or group of users to grant or revoke access to the current
object. |
Take ownership |
Click Take ownership to
grant ownership of the current object to the user or user group.
Note:
This option may not be available, depending on your
resource limits. |
Use these settings for all reports under
this folder |
Check this check box to apply the security settings
to all reports and subfolders contained in the current folder |
REPORT PROPERTIES - GLOBAL VARIABLES TAB
The Global Variables page
of the Report Properties window opens when you select Report--> Properties,
then click the Global Variables tab.
The following are rules for global variables:
- If a global variable is set at the main folder level,
then the global variable is set for each report in the folder when
the folder is run.
- If a global variable is set at the report level,
it becomes the default for the report. If a folder is run and the
folder has the same global variable value as the report, then the
report value is used.
- If a global variable is set at the sub-folder level and
a global variable has been set from the folder being run or from
the individual reports, then the global variable for the sub-folder
is ignored.
Table 61. Global Variables Options
Field |
Description |
Variable Name |
Type the name of the global variable in the highlighted
text box.
Global variable names must be unique, they are not case-sensitive,
and they can begin with an ampersand (&). |
Variable Value |
Type the value for the variable in the highlighted
box. |
Add |
Click Add to add a global
variable. |
Remove |
Click Remove to remove
a global variable. |
Run |
Click Run to run the SQL. |
Add to Favorites
Select Report--> Add to Favorites to
add a pointer in your Favorites folder to the selected table, procedure,
or query on a server.
The report will be added to the top of your Favorites folder
with the following naming convention:
Objecttype OWNERNAME.OBJECT NAME
For example:
Query QMFGUEST."SELECT"
Create shortcut
Select Report--> Create shortcut to
create a shortcut (.qrs file) to a report in your Favorites at a
specific location.
You can create a shortcut to reports in your Favorites folder.
The shortcut enables you to access a report by launching QMF Report
Center and locating the report using the shortcut.
Follow these steps to create a shortcut:
- Select a report.
- Drag the report to your Favorites folder.
- Select Report--> Create shortcut.
- Specify the filename and location for the shortcut.
- Click OK.
The file extension .qrs is added to the
filename.
- Double-click the shortcut to launch the report.
QMF for Windows opens, runs the report, then closes. The report
remains open.
Note:
Shortcuts are launched when the report name is found.
Save changes to Public Favorites
Select Report--> Save changes to Public Favorites to
save report changes in the Public Favorites folder.
New Report linked to locally saved query
Select Report--> New Report linked to locally saved query to
create a report by selecting a query saved locally on your network
or workstation.
- Select the Favorites folder.
- Select Report--> New Report linked to locally saved query.
The Locate the QMF for Windows query to link to dialog box opens.
- Select the query.
The query is added to the Favorites folder.
Note:
Only the SQL and server information are used. Other
options saved with the .qry file are ignored.
Editing SQL in QMF Report Center
Follow these steps to edit SQL for a report in QMF Report Center.
This is the only situation where SQL can be edited by QMF Report
Center.
- Locate the report on your local machine.
- Double-click on the report.
- Edit the QMF object text.
- Save the changes.
New folder
Select Report--> New folder to
create a folder within the current folder.
Empty recycle bin
Select Report--> Empty Recycle Bin to
remove the deleted items from the Recycle Bin.
Exit
Select Results--> Exit to
exit from QMF Report Center.
