The  Report  panel allows the User to view the report that is generated by running a SELECT query. The appearance of the report is controlled by changing attributes in the  Layout  panel. Output generated from UPDATEs, INSERTs, or batch queries can is also viewed in the  Report  panel, but Layout control is not available for this type of output.

Paging between page sets
When a report is produced, only a certain number of rows of data are displayed at one time. In order to move between "page sets", the User must click the appropriate navigation buttons:
First First
Skip backward Skip backward
Back Back
More More
Skip forward Skip forward
Last Last

Unavailable options are grayed out. Pressing Back will take you 1 pageset backward. Pressing More will move you 1 pageset forward. The Skip options will move from the current report row to either halfway to the end of a report, or halfway to the beginning of a report.

There are two limiting factors that determine how large of a continuous report page can be created. These are the Report rows and Maximum output file size settings applied when QLR Manager was installed. These values default to 500 rows and 5 MB.

Display whole report:

The capability exists to override the number of report rows displayed for each "page set" in the Report Body section of the  Layout  panel. This can be useful for printing a large continuous report using the Print displayed output option in the Report tools pop-up. The value entered for Max displayed rows can be used to increase the page set size and be saved for use with a particular report. If the Layout is saved as the same name as the query or wizard producing the report, it will become the default layout applied when the query, wizard or menu item is executed.

Output can also be printed to a PDF file using a PDF writer such as Adobe Acrobat or CutePDF (available free from Increasing the max displayed rows also provides a means of creating a large, continuous PDF of the report output.

Note: When printing to a PDF writer, it is usually desirable to print in full color. The default browser printing behavior is to avoid printing background colors to save ink. Instructions are provided in Printing output that describes how to change these settings in common browsers.

Column sorting

If all of the data for a report can be cached and the "Allow sorting" checkbox is checked in Titles & Footers section of the  Layout  panel, the data in the report can be sorted by clicking the sort arrows in the column heading. The column heading text can also be clicked to execute the sort. The first click will sort the column data ascending and the second will sort descending. QLR Manager sends a request back to the server to sort all of the data associated to the report, which may be more than the data that is currently being displayed.

The sorting is applied within any Report Breaks that have been defined in the  Layout  panel. Columns that are defined with a Break action cannot be sorted, as the sorting feature is intended to sort data within the Layout's break structure. In Table and Pivot style Layouts, the column data that is spread across the page as a result of the Table or Pivot action cannot be sorted.

Logging off

Once the User has connected with an ID and password, a  Log off  button will appear in the upper right corner of the QLR Manager Header. Although it appears on all panels, it is most relevant to report generation.

When QLR Manager generates the web pages it displays, including report pages, it creates the information in temporary storage. Clicking the  Log off  button will erase these files and take the User back to the  Connect  panel. Although it would be very difficult (never say impossible) for someone to access these report pages, this provides a means to delete from the server all pages created during the User's session.