How to Run an SQR Report

Access Reports

 From the MyCampus home page, select the MaineStreet Icon, then select:  Enterprise Applications > Campus Solutions-Reporting DB > University of Maine Systems >

From here, select the folder you need. 
For the example that follows, select Student Admissions>Reports>Admissions Report Home

The Admissions Reports page opens:

back to top

The Run Control ID page for the selected report opens:

Create a Run Control ID

The first time you run a report you must create a Run Control ID.  Run Control IDs are used whenever a process is run in PeopleSoft.
They allow you to create, save and reuse a list of reports. Only you will see the Run Controls you create. If you already have a Run Control ID, enter it here.

After you have created Run Control IDs for this process, you will select the Find an Existing Value tab to look up the Run Control IDs.
When you select a Run Control ID, it will take you directly to the page to run the process associated with it. If you only have one Run Control ID,
the system will take you immediately to the Run Control page for that process when you select the Find an Existing Value tab.

The Run Control page for the selected report opens

back to top

Running a Report

The parameters available for reports vary according to the nature of each report. Enter the required parameters (noted by *) and select thebutton.

The Process Scheduler Request page opens.

In the Process List section of the page, verify the report you want to run is checked in the Select column.
The Process Type column shows whether it is a Crystal or SQR report. In the Format column, choose whether the report should be generated in PDF or Excel format. 

You do not need to enter any other information on the Process Scheduler Request page.  Now you're ready to run the report!

The Process List page opens:

This is where you will monitor the status of your report and eventually access a link to it.

The Run Status will initially appear as “Queued,” then “Initiated,” then “Processing” and finally as “Success.”
Select Refresh  to update the information displayed in the Run Status column.

Once the Distribution Status is “Posted”, click the Details link to access the page where the report is listed.

You can access reports you have run up to ten days after the run date. To narrow or broaden the list of reports listed,
adjust the settings entered in the “Last:”  fields of the View Process Request For section.

After the Process Detail page opens, select View Log/Trace:

On the View Log/Trace page, select the output file from the list to open it.

The report appears as follows:

back to top

 Anatomy of an SQR Report

back to top