Creating Report Instances and Layouts

Each Excel spreadsheet created with PS/nVision is a report instance or a report layout. A report instance contains data that PS/nVision has retrieved from your PeopleSoft database. Every report instance is based on a report layout. PS/nVision uses the specified layout to determine the data to retrieve for the report and how to display it.

Note:

Beginning from PeopleTools release 8.51, all PS/nVision layouts and all report instances (that are used to perform drilldown) must be in OpenXML (.xlsx) format. If you want to use existing layouts and reports that are in Excel 2003 (.xls) format, you must convert their format to .xlsx.

See Converting Existing Layouts and Reports to OpenXML Format.

Creating a PS/nVision report is a three-step process:

  1. Define a report layout that specifies the ledgers, criteria, or queries to use for the report and how to format the report.

    The report layout is an Excel spreadsheet that does not include actual PeopleSoft data; it defines the structure of the report—query information, criteria, text, formulas, graphics, formatting, or other information. After a layout has been saved, you can use it repeatedly to run reports.

  2. Create a report request, specifying the layout and runtime options for the report.

  3. Run the report request, using the nVision menu in Microsoft Excel, the Run button on the request dialog box, or a button/macro that calls PS/nVision to run the report.

    As the report runs, a copy of the layout—an instance—is populated with data and is saved as a normal spreadsheet file. You can produce multiple instances of the report. For example, you might provide an inventory report for each location within your organization. Each instance is an individual report with current data from your database, selected and formatted according to the instructions in the report layout.

Note:

If you are using a scope with your report, you can produce several instances from one layout with one report request.

Most PeopleSoft applications deliver predefined PS/nVision report layouts (such as Salaries by Department, Balance Sheet, Profit and Loss, and Operations Summary). Like any spreadsheet, a layout spreadsheet can be cloned and modified; you may rarely need to build one from scratch.

Besides the features that are available through PS/nVision, you can use Excel features to personalize layouts (and the resulting reports). For example, Excel includes dynamically linked charting and drawing tools for creating colorful graphs and diagrams. Because the layout is the basis for all reports produced from it, you can format and enhance the report once and get the benefits automatically each time the report is run.

Note:

If you’re working with PeopleSoft Financials products, you may be interested in using ledgers with PS/nVision and taking advantage of the TimeSpan feature to define reports that roll from period to period without any changes to the layout. Using TimeSpans, you can have the same layout retrieve year-to-date data based on the as of date for which the report is requested.

See Understanding Ledger-Based Matrix Layouts, Defining Ledger Criteria, Understanding Report Scopes, Defining Scopes.