Launching Crystal Reports with Microsoft Windows-based Query


Concept


Steps:

  1. Begin by opening to the Application Designer Signon dialog box.

     

    Double-click the Application Designer menu.

    Step 1
  2. Use the Application Designer Signon dialog box to sign on to PeopleSoft Application Designer.

    Step 2
  3. In this example, you will accept the values for Database Name as T1B84901 and User ID as PTRPTG.

    Step 3
  4. Click in the Password field.

    Step 4
  5. In this example, enter PTRPTG as password.

     

    Enter the desired information into the Password field. Enter

     "PTRPTG"
    .

    Step 5
  6. Click the OK button.

    Step 6
  7. Use PeopleSoft Application Designer to perform numerous development tasks including:

    •  Run queries directly to Crystal Reports from Query Designer.

    •  Create record and field definitions.

    •  Build SQL tables and indexes.

    •  Create and modify pages for the user interface.

    •  Create and modify components (groups of pages).

    •  Work with style sheets to customize the appearance of applications.

    Step 7
  8. In this example, you will run a query directly to Crystal Reports 9 from Query Designer using the Go, Query menu.

     

    Click the Go menu.

    Step 8
  9. Click the Query list item.

    Step 9
  10. Use Query Designer to run queries directly to Crystal Reports 9.

    Step 10
  11. In this example, you will open a query using the File, Open menu.

     

    Click the File menu.

    Step 11
  12. Click the Open list item.

    Step 12
  13. Use the Open Query dialog box to search and select a query from the list.

    Step 13
  14. Click the down arrow next to the Name field.

    Step 14
  15. A list of existing queries appear.

     

    In this example, you will highlight the name of the CRSE_SESSIONS query that you want to base the report on.

     

    Double-click the CRSE_SESSIONS list item.

    Step 15
  16. Use the Run Query button to run the query.

     

    Click the Run Query button.

    Step 16
  17. The system displays the CRSE_SESSIONS query report results.

    Step 17
  18. Click the Run to Crystal button.

    Step 18
  19. The system automatically opens the Crystal Reports application and creates a new Crystal report.

    Step 19

You have successfully launched Crystal Reports with Microsoft windows-based query.

Table of Contents  Start Topic