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.
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:
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.
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 www.cutepdf.com). 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.
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.
Data filtering is available when all of the report data can be cached into memory. The higher the configured PHP memory_limit, the greater the number of reports that can be cached, and therefore filtered. Filtering allows the User to specify the records that will appear in a report. This comes in handy with queries that take a long time to execute or to conduct a quick "what if" analysis of the data. The filtering pop-up up window is accessed by clicking on the Filter icon located in the upper right corner of the Report panel. If this icon is not present, the data cache limit has been exceeded and filtering is not available. Clicking the Filter button in the filtering window will begin the filtering process. When criteria is entered for multiple columns, the records found must meet all of the entered criteria.
The filtering window displays the Report columns as found in the report Layout. The second column allows the User to select a filtering Comparison operator. The third column is used to enter the comparison Criteria. An example of a basic filter for a report column containing state names could be Montana. There is no need to surround the comparison values with quotes. Multiple criteria values can be entered separated by commas such as Montana,Idaho,Utah. Multiple entries can be used for comparison operators of:
Equals, Not equals, Begins with, Not begins, Ends with, Not ends, Contains and Not Contains
The format for the Between operator is lower value and higher value, such as Between Alaska and Montana. Notice the word and separates the lower and higher values. The Contains all operator also accepts multiple entries. When used, all of the values entered must be found in that column's data.
The underscore character can be used to force the use of a space when searching with the different comparison options. For example, suppose the data is searched for the term inventor but the data contains the words "inventor" and "inventory". Both of these would be found when looking for "inventor". If the search criteria is changed to _inventor_, then only "inventor" would be found. The underscores can be used at the beginning and the end of the search words. If the word "inventor" is at the start or end of the data field, it will be found even when using the underscore character.
There is a special case for the Contains and Contains all comparisons which allows for a search of instances that contain certain values, and at the same time exclude certain values. For example, suppose the report contains purchase order data descriptions for software purchases, and it is desired to find all instances of Excel software, but not Microsoft Excel. This can be accomplished by using the != prefix to exclude an entry by entering Contains comparison data as excel,!=microsoft. The underscore characters can also be used in conjunction with !=, such as excel,!=_microsoft_.
The Case sensitive checkbox will force the filtering to be case sensitive.
The data that is examined is based on what is stored in the database. For example, date data may be stored as '2016-06-10', but the data has been formatted using a Layout formatting option to display as 'Jun-10-2016'. Checking the Based on displayed checkbox, will filter the data to find all dates that contain the displayed date format, such as "jun".
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.