Go to Process Schduler -> Processes ->
Open the your crystal process definition
Go to Overrude options tab and Append the following to the Parameter List.

-LX0

3. How do you run an SQR in PeopleSoft ?.
A. You can run in 2 ways
i) On client side using SQRWIN.exe
ii) On Server using Process Scheduler (Process Scheduler is also called as Batch Server).

4. How do you run an online job or process in PeopleSoft ?.
A. You can run using a Run Control page, once you click the run button it will submit the job to Process Scheduler. to check the status of submitted job click on Process Monitor link.

5. How do you check the process status in peoplesoft ?.
A. go to PeopleTools -> Process Scheduler -> Process Monitor.

6. How do you design a query in PeopleSoft ?.
A. Can be designed in 2 ways

i) Open App Designer then PeopleTools - > Query
ii) Login into 3-tier then go to Reporting Tools -> Query -> Query Manager.

7. What do you need to do to see a table in query designer ?.
A. Table needs to be added to a Tree to see the table.

8. How do you convert Panels to Pages ?.
A. Add all the Panels to a project and login to 3-tier (web) and go to PeopleTools -> Utilities -> Administration -> Convert Panels to Pages.

9. What are Translate values ?.
A. Transalate values will be assigned to fields where you will have a common 3 character values for example Federal ID filed could have values like SSN , TIN .

10. What is a Prompt Table ?.
A. Prompt table is used to prompt the valid values for a specific filed on a page. Prompt table can be a view or a table.

11. What are the major section in an SQR ?.
A. The main section is Begin-Program and End-Program, Begin-Procedure and End-Procedure.

12. How do you write a SQL statement in an SQR ?.
A. for select BEGIN-SELECT and END-SELECT for other BEGIN-SQL and END-SQL.

13. How do you debug an SQR program ?.
A. By putting Display and Show statements in the program and then check the out put file or use debug statement.

14. What output extension does the SQR will have if you run it from a client ?.
A. It can be .spf or .lis based on the SQR flag set.

15. What kind of out put you can get when you run from web (3-tier) ?.
A. It can be PDF, HTML, e-mail , LIS etc..

16. What is report repository ?.
A. Once the process scheduler finishes processing it will post the out put files to Report repository.

17. What is Report Manager ?.
A. Report manager can be used to see the reports in the report repository.

18. How do you see the newly created Component in the 3-tier menu.
A. You need to register the component by using Application Designer.

1. Open Application Designer.
2. Click on Tools - > Options
3. Under Insert Definition into Project, select ‘When definition is modified ….’ Option.
4. Under Related Definitions options, select ‘Prompt user to pick ….’ Option.
5. Click OK.