Data, Analytics & Reporting Technology Services
In PeopleSoft, there are a number of reporting options available. These options include PSQuery and SQR Reports. This report specifically covers running the SQR Reports.
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.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:
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
Running a Report
The parameters available for reports vary according to the nature of each report. Enter the required parameters (noted by *) and select the
button.
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 Run Control page opens and you will see a Process Instance number has been assigned.
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.
Attachments:
SQR Reports-How to Run.doc (application/msword)
SQR Reports-How to Run.doc (application/msword)
Dart 2 just the dart.png (image/png)
1Admissions.PNG (image/png)
1EnterpriseApplications.PNG (image/png)
3.AdmissionsReportsPg.PNG (image/png)
4.AdmissionsStatusReport.PNG (image/png)
5.AddNewValue.PNG (image/png)
6.RCI.PNG (image/png)
7.RunControlPg.PNG (image/png)
8.RunButton.PNG (image/png)
9.ProcessSched.PNG (image/png)
10.ProcessType.PNG (image/png)
11.RunReport.PNG (image/png)
12.ProcessInstance.PNG (image/png)
13.ProcessMonitor.PNG (image/png)
14ProcessList.PNG (image/png)
15ExpDays.PNG (image/png)
16ProcessDetail.PNG (image/png)
17ViewLogTrace.PNG (image/png)
18.PNG (image/png)
11.RunReport.PNG (image/png)
19Report.PNG (image/png)
1Admissions.PNG (image/png)
10.ProcessType.PNG (image/png)
16ProcessDetail.PNG (image/png)
SQR Reports-How to Run.doc (application/msword)
Help-button-800px.png (image/png)
SQR Report Anatomy.jpg (image/jpeg)
