What You Should Know
Print a Report
Reports are displayed in HTML (web page) format by default. For a printable format, you can change the view from HTML to PDF.
Learn more about how to Print a Report.
Export Report to Excel
Reports are displayed in HTML (web page) format by default. You can choose to export the report to the following Excel options:
- Excel 2007 Data - Removes all the report formatting and will be a real-data extract or "data dump." This is the recommended Excel option for filtering and pivoting.
- Excel 2007 Format - Includes additional cell formatting (for example, borders, fills, column widths), as well as space for a report header that contains the Princeton University logo. This Excel option also allows for millions of rows that can be exported into one sheet.
- Excel 2002 Format - Similar to View in Excel 2007 Format. Includes additional cell formatting (for example, borders, fills, column widths), as well as space for a report header that contains the Princeton University logo. The difference is that the View in Excel 2002 Format option will only export up to 65,000 rows in one sheet. Additional rows will be exported to a different sheet.
- CSV Format - Saves a workbook as a comma-delimited text file for use in various applications, and ensures that tab characters, line breaks, and other characters are interpreted correctly. If you intend to format data, it is recommended that you use the other Excel options, as CSV files cannot store other information like formatting which comes standard in Excel.
Learn more about how to Export a Report to Excel.
Navigate HTML Output
By default, reportsdisplay in HTML (web page) format. The report header appears across the top of the page, and report results appear in the middle of the page. At the bottom of the page, you will find links that enable you to scroll through the report pages.
Learn more about how to Navigate Report HTML Outputs.