Quick Guide: Create A Report Request

This guide provides an overview of several methods for creating reports in your personal library, but does not include a detailed discussion of the various menus and functions. For more information, refer to the topics referenced.

Type a request from scratch

Step 1:

To create a new report from scratch in your personal library, press the F2 key at the main menu. Type a name (e.g., NEWHIRES) and press enter.

|------- New Report Request --------|

| ENTER REPORT REQUEST NAME |

| OR |

| LEAVE BLANK TO ENTER FOCUS ONLINE |

| |

| NAME: NEWHIRES |

|-----------------------------------|

Step 2:

Type the commands inside the blank report request. After all the commands are typed, press the enter key.

EDIT PD.CSUCFOC.CTBYZ(NEWHIRES) - 01.01 Columns 00001 00072

Command ===> Scroll ===> PAGE

****** ********************* Top of Data ***************************

'''''' (type FOCUS commands here)

****** ********************Bottom of Data **************************

Step 3:

Press the F3 key to save and return to the main menu.

EDIT PD.CSUCFOC.CTBYZ(NEWHIRES) - 01.01 Columns 00001 00072

Command ===> Scroll ===> PAGE

****** ********************* Top of Data ***************************

000001 -* NEW HIRES IN THE LAST CALENDAR MONTH

000002 EX JACPS

000003 TABLE FILE AC

000004 PRINT PS:TITLEA AC:POSIT16 AC:WORKLOC

000005 BY AC:WNAME

000006 IF AC:EMPDATE FROM 05/01/03 TO 05/31/03

000007 IF RECORDLIMIT EQ 5

000008 END

****** ********************Bottom of Data **************************

Copy a request from your personal library

Step 1:

To create a new report by copying commands from another member in your library, press the F2 key at the main menu. Type the new name in the pop-up window and press enter.

|------- New Report Request --------|

| ENTER REPORT REQUEST NAME |

| OR |

| LEAVE BLANK TO ENTER FOCUS ONLINE |

| |

| NAME: NEWHIRES |

|-----------------------------------|

Step 2:

Inside the blank report request, type COPY at the command line followed by the name of the report request that is being copied (e.g., EMPLIST) and press enter.

EDIT PD.CSUCFOC.CTBYZ(NEWHIRES) - 01.01 Columns 00001 00072

Command ===> copy emplist Scroll ===> PAGE

****** ********************* Top of Data ***************************

''''''

****** ********************Bottom of Data **************************

Step 3:

After the commands are copied, you can edit the report request. Press F3 to save and return to the main menu.

EDIT PD.CSUCFOC.CTBYZ(NEWHIRES) - 01.01 Columns 00001 00072

Command ===> Scroll ===> PAGE

****** ********************* Top of Data ***************************

000001 -* EMPLOYEE LIST - RUN QUARTERLY

000002 EX JACPS

000003 TABLE FILE AC

000004 HEADING CENTER

000005 "EMPLOYEE LIST"

000006 PRINT AC:WNAME AS 'EMPLOYEE NAME'

000007 AC:CLASS AS 'CLASS'

000008 PS:TITLEA AS 'TITLE'

000009 END

Copy a request from the common library.

Step 1:

From the main menu, press the F6 key to swap your personal library with the common library.

CIRS COMMON LIBRARY

Cmds B Browse C Copy D Delete E Edit Row 1 of 417

P Print R Rename S Submit Batch O Online Execution

Cmd Name Description Changed

_ AAINDEX INDEX OF ALL FOCUS REQUESTS IN THE COMMON 2003/07/22

_ AAMSG THIS FOCEXEC CONTAINS A 6 MONTH BACKLOG 2003/07/23

_ AANWHIR3 AFFIRMATIVE ACTION NEWHIRES 2003/07/29

_ AAPGRP NO DESCRIPTION FOUND. 1999/03/15

Step 2:

From the common library, locate the report request by pressing the F4 key. Type the full or partial name of the member (e.g., DAILY) in the pop-up window and press enter.

|----------Locate Report Request---------|

| ENTER REPORT REQUEST NAME |

| OR |

| BEGINNING LETTERS |

| |

| NAME: daily_____ |

|----------------------------------------|

Step 3:

The system will display the first occurrence of the character string at the top of the library. To copy a report, type a 'C' at the command line to the left of the name and press enter.

CIRS COMMON LIBRARY

Cmds B Browse C Copy D Delete E Edit Row 1 of 417

P Print R Rename S Submit Batch O Online Execution

Cmd Name Description Changed

c DAILY CREATES 4 REPORTS FOR VERIFYING DAILY PAYROLL 2003/08/13

_ DAILYDWN TO RUN DAILY AND GREEN CYCLE 2003/05/28

_ DAILYPAY DAILY PAYROLL REPORT-PAGE BREAKS BY PIP, A54, 2003/05/23

Step 4:

At the confirm copy screen, press enter to accept the default name and copy to your library. After copying, press F6 to return to your personal library.

|------------- Confirm Copy ----------|

| |

| COPY DAILY OF COMMON LIBRARY |

| TO DAILY OF PERSONAL LIBRARY |

| |

| ENTER TO CONTINUE - F3 TO CANCEL |

|-------------------------------------|