In this section: |
The canvas displays a preview of the report being created or modified on the canvas when you are in the default Live Preview. To select Live Preview, go to Home tab, and in the Design group, click Live Preview, or on the View tab, in the Design group, click Live Preview. The canvas is always fully maximized and cannot be minimized, cascaded, or tiled. However, a blank canvas opens when there is no report.
The canvas displays either live data or sample data.
When you select Data from Source, a live preview of the report being built, with records from your data source, is refreshed on the canvas as you add, remove, and style fields in the report.
When you use live data, you can set the number of records that display in your content by selecting a value from the Records menu. Displaying more records gives a more complete view of your data at design time, but may result in slower performance.
Note: Prior to Release 8207, when creating content using an Oracle Database 12c data source, design time record limits were applied prior to aggregation. In Release 8207 and higher, the record limit when using Oracle Database 12c is applied after aggregation.
When you select Use Sample Data, the canvas displays sample data based on the field type, with the same formatting and styling used to display live data.
When you execute a report, the canvas displays the Output window. If the Output is minimized, or if there is no report to preview, the canvas is blank. To change the canvas view, you can select Query Design view or Live Preview from the Design group of the View tab or Home tab.
The following image shows the canvas, which displays a chart preview when you first launch InfoAssist to create a chart. The Resources panel appears to the left of the canvas.
When working with a report in Live Preview, you can rearrange the columns of the report by dragging them to the left or right, depending on your display preference. If the column is numeric, you are presented with the option to Drop as Sum or Drop as Sort, as shown in the following image.
Note: If you select Drop as Sort, the values are listed individually and they are sorted. If you select Drop as Sum, the values are summed for that particular row. The default is Drop as Sum.
When placing the column in a new location, an indicator bar displays, indicating the location of placement for the moved column. This allows you to see where the column will be placed before you actually perform the operation.
Note: Column sort order can also be rearranged by dragging the fields in the Query field containers of the Query pane to reorder them. For more information, see Using the Query Design Pane in the Resources Panel.
If you create a filter, then the filter appears in the Filter pane.
If you click Query on the Home tab, in the Design group, the Query and Filter panes expand in to the canvas.
This provides a larger area for displaying the Query and Filter panes. This feature is useful when you are designing a report with multiple filters or numerous fields.
Depending on whether you are creating a report or a chart, the Query pane displays selected data source fields using different types of Query field containers.
Related Information:
Reference: |
When you run a report, the output appears, either in a tab on the canvas, or in a new browser window. You can create and display output in several different ways, depending on the following options. You can select these options on the View tab, in the Output Window group:
Output window and tab options are also available in the status bar, and output window display options are also available in the Navigation taskbar.
Note: When you run a report, tab focus is not on the output window and pressing the Tab key does not move the selection. To move the Tab focus out of the output window, press F6.
The following are output target options that you can select.
The following are output view options (Arrange) that you can select.
The Output window can display report output in the following formats: HTML, HTML5, , PDF, and .
Note: Excel and PowerPoint formats open in their native programs in a window external to InfoAssist.