Report Types

Using App Studio, you can create the following report types using graphical tools or the WebFOCUS syntax:

• Tabular report. Displays information in rows and columns. This is the basic report type, incorporating the fundamental reporting concepts. Most of the other report formats build on these concepts. You can drill down or roll up data hierarchies, pivot fields from columns to rows (or vice versa), and separate information by filtering or querying data sources based on specified criteria or thresholds. You can also create drill through reports that contain a summary report and detail reports, where the detail reports contains all the detail data for designated fields in the summary report. You can display these reports in many different formats, including HTML, Excel®, PowerPoint, and PDF. For more information, see Creating a Tabular Report.
• Active report. Designed for offline analysis. When using an active report, you can interact with data, using analysis options similar to those found in an Excel workbook. Since no connection to a server is required to view the data or use the analysis options, you can save and use the report anywhere. Analysis options include filtering, sorting, charting, and much more. For more information, see Creating an Active Report.
• Excel Compound and Table of Contents reports. Provides a way to generate multiple worksheet reports using the XLSX output format. By default, each of the component reports from the compound report is placed in a new Excel worksheet. A Table of Contents report provides a way to generate a multiple worksheet report where a separate worksheet is generated for each value of the first sort field (BY) in the report. For more information, see Creating an Excel FORMULA Table of Contents Report.
• Financial report. Specifically designed to handle the task of creating, calculating, and presenting financially oriented data, such as balance sheets, consolidations, and budgets. You design the content of the report on a row-by-row basis using a field (called a FOR field) that identifies each row, such as an account field. Once you have created the FOR field, you can build these reports from the Matrix tab. This organization provides a number of advantages, including easily defined inter-row and inter-column calculations. For more information, see Creating a Financial Report.
• Precision report. Gives you an additional set of tools that make it easy to control the precise placement of objects and data in the report output. For example, with a precision report, you can quickly create a layout that is perfectly aligned for a preprinted form (such as a Bill of Sale or a tax form) and that automatically breaks out one record per report page. You can convert an existing report into a precision report or you can create a new precision report. For more information, see Creating a Precision Report.
• SQL request. You can retrieve information using the SQL reporting language, and can directly incorporate WebFOCUS formatting commands. For more information, see Creating a Tabular Report Using an SQL Request.