Creating 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)

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

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

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

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

'''''' (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 F​rom 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.  

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.