Adding a New Run Control for BI Publisher

pdf icon 50p

This job aid demonstrates how to set up a Run Control for the purpose of producing a BI Publisher report. BI Publisher reports, using Query Report Scheduler, require the use of a Run Control, which is a slightly different process than using PS Query. The Run Control configuration is an essential step in generating a report, as a run control can be used time and again—with minor changes, if necessary—to generate a BI Publisher report. 

View or download a PDF of this guide with images

Privacy Disclosure
Disclosure of information from student records is governed by the Federal Family Educational Rights and Privacy Act (FERPA) and in part by the State of California Education Code. UCB maintains a campus policy governing disclosure of information from student records. This policy provides reasonable interpretations of those laws and protects the student’s right of privacy as guaranteed by the State of California’s constitution.  For more information, the entire policy can be found at:
You must not release any private student information to any person or organization without the student’s written consent, and must only handle all UCB information for authorized work-related purposes, according to the Minimum Security Standards for Electronic Information (MSSEI).
Private student information is considered Level 1 and includes, but is not limited to, academic records, information in personnel files, student conduct issues, SID, certain personal contact information, as well as other sensitive information encountered while on the job. Level 2 information, which if exposed to unauthorized persons, causes extreme impact. It includes but is not limited to Social Security Numbers, Credit Card Numbers and medical information.


1. In Campus Solutions, navigate to Reporting Tools > BI Publisher > Query Report Scheduler.
The first time you run a BI Publisher report using Query Report Scheduler, you will use the Add a New Value page to create a new run control. Once a Run Control has been saved, it will be available for use time and time again and can be run as is or reconfigured. Run controls are specific to the user.

2. In the Query Report Scheduler window, click the Add a New Value tab.
3. Click in the Run Control ID text box, and type a new run control name. Click Add.
    NOTE: Run Control names should not contain spaces, and when emulating the desired report name should not contain special characters.
4. In the Query Report Scheduler window, verify the Data Source Type is Query and click in the Report Name text box, and use the Lookup list magnifying glass to search for the report you want. 
5. From the Search Results, select the required report.
6. In the Search Results parameters window, type the term in the Term field, or click the Lookup icon, and select the term from the Lookup list.
7. Click the OK button.
8. If necessary, change the parameters by clicking the Update Parameters link. (When done, click the OK button to return to Query Report Scheduler).
9. Click the Run button.
10. After accepting the default configurations for Type and Format, or changing them, click the OK button.
11. Within the Query Report Scheduler window, click Save.
12. Click the Process Monitor link.
13. Run Status should equal Success, Distribution Status should equal Posted, and Details should equal Details. If not, click Refresh before continuing.
14. Click the Main Menu link.
15. Navigate to: Reporting Tools > Report Manager.
16. Click the Administration tab.
17. Click the PDF of the report, shown in the Report List. (It should be the top report displayed.)
18. Once you select the PDF, that PDF file will appear in a new browser tab or window.
       Using the Acrobat command bar, you can save or print your report.
19. When done, close the report’s browser tab to exit the report.
20. In the Navigation Bar that runs across the top of the window, click the Home button to return to Campus Solutions’ home page, or click Sign out to exit Campus Solutions.


For questions or assistance, please contact SIS Production Support:

For additional SIS resources, please visit:

Service category