How To: Run, Print, Save or Export ReportMart3 Reports on a PC

Who does this?  Stanford Administrative Staff using ReportMart3 from a PC

When?  Reconciling Oracle Financials' transactions (purchases, expenditures, reimbursements, etc.) or managing funds. Exporting reports to Excel is a useful tool for comprehensive analysis

How?  Using ReportMart3, Adobe Reader or Microsoft Excel applications. Learn about requesting access to ReportMart3.

On this page:

 

Find and Run a Report (4 steps)

step 1

Launch ReportMart3:

  1. Click https://reportmart3.stanford.edu.


    2. Note 1:  Or from the Stanford network type reportmart3 in the browser address field or enter https://reportmart3.stanford.edu if off campus.

    Note 2:  Or from the Staff section of the Gateway to Financial Activities website, use the pull-down menu under Launch Applications (upper right section of every staff page) to select ReportMart3 and click Go button.

    Note 3:  The recommended browser for PC's is Internet Explorer.

    Note 4:  Mac users connect via Citrix/Connect. See How To: Run, Print, or Export ReportMart3 Report on a Mac.

  2. Enter your SUNet ID and password if prompted.
step 2

Find a report from a Category:

  1. Click the + by Corporate Categories.
  2. Click All Reports.
  3. Scroll down the list to the report name.


    4. Note:  The list of reports is in alphabetical order.

  4. Click the report title link.
step 3

Find a report using search:

  1. Enter part of the Title of the report in the Search field.


    2. Note:  The search entry must be sequential characters in the report title.

  2. Click Search button.
  3. Click the report title link.
step 4

Enter search terms in the Prompts page and run report:

  1. Enter the Prompts needed to find the data.


    2. Note 1:  Enter only the prompts necessary to find the data. Too many prompts can slow the system.

    Note 2:  If you know all the prompt values enter them directly on the prompt screen. If you need to access 'Lists of Values' to choose a value click on Advanced Prompts at the top of the prompt panel. See Resources & Job Aids: Using Advanced Prompts in ReportMart3.

  2. Click Run button.
back to top

Print or Save Report as PDF, or Export to Excel (5 steps)

step 1

Follow the steps in Find and Run a Report.

step 2

Re-display the report to the desired format:

  1. Select the view of the report you want to display. The default is All Tabs. Other options vary depending on the report. They may include Full Display or Brief Display.
  2. Click PDF View button as needed.


    3. Note:  Reports in ReportMart3 can be displayed two ways, as an Adobe Acrobat PDF file or as an HTML web page. The default display depends on the report type as noted in ReportMart3 – Desktop Intelligence (defaults to PDF) or Web Intelligence Document (defaults to html).

step 3

To print a report:

  1. Click Print button in the Adobe Acrobat menu bar.
  2. Select the printer.
  3. Click OK button.
step 4

To save report as a PDF file:

  1. Click Save button in the Adobe Acrobat menu bar.
  2. Change the file name as needed.
  3. Click Save button.
back to top

Export Report to Excel (4 steps)

step 1

Follow the steps in Find and Run a Report.

step 2

Re-display the report to the desired format:

  1. Select the view of the report you want to display. The default is All Tabs. Other options vary depending on the report. They may include Full Display or Brief Display.


    2. Note:  Many financial reports have a Data Download tab that is specifically formatted for export.

step 3

Export the report:

  1. Click excel icon Export.
  2. Click Save button.
  3. Navigate to the folder where the file is to be saved.
  4. Enter the File name if you want to change the default.
  5. Click Save button.
step 4

Open the file:

  1. Open the saved file in Excel.
back to top

 

What Happens Next?

  • Report data may be used to reconcile Oracle Financials' transactions, such as purchase requisitions, iOU reimbursements, or journal expenditures.

Questions?

back to top