Running SQR Program in Different Ways

Running a SQR Program threw SQR Window 

> Lets take a simple following program

> Open SQRW Window

-- >Browse Report name ,fill the details of DataSource,Username and Password 


-- >Fill up the Report arguments






 >Click Ok ,To get SPF format




Running a SQR Program through Process Scheduler  

1) Select Run Control Record , Run Control Records are used to save the input parameters for processes. Lets use predefined record PRCSRUNCNTL with some of the Required Fields (OPRID,RUN_CNTL_ID ..), Here there are no I/P Parameters are there

 

Here OPRID & RUN_CNTL_ID are key fields

2)Select Run Control Page , Lets use the predefined page PRCSRUNCNTL (Standard Page). Note that Run Control page is linked to the PRCSRUNCNTL Run Control record.Here PRCSRUNCNTL uses fields exactly from PRCSRUNCNTL Record.

3)Create a new custom component for report










4) Add Search record

 

5) Add Component to Menu & Register.

--> We are done with creating an application.

 --> Now we need to create process definition for our SQR Report & Add it to newly created component 

1) Create Process Definition 

Navigation : PeopleTools - Process Scheduler - Processes -Add a New Value

  








--> Add a new process definition like below

Here note that no extension is needed when entering the program name

--> Click Add

--> Process Definition Page Opens 
--> Click on next tab Process Definition Options & Give the details of our previously created Component & Process Groups under Process Security 

 Finally Save the Process & place the program into right directory as shown below

 


 -->Now Finally we need to make our program API Aware

--> Process Monitor Page

--> Click on Details

 -->Click View On Log/Trace 

--> Click On File List ,PDF File to O/P

Running in CMD

Use the following cmd to run in command line