KnowledgeBase 00035: Panning and Scrolling in the Query Processor

The QM query processor includes useful features to pan reports that are wider
than the screen and to scroll back through pages of a report.

Panning

Developers sometimes have to juggle field display widths to get the columns
required in a report to fit the screen. The pan feature of QM's query processor
allows a report to be wider than the screen, panning all or part of it to show
the columns of interest by use of either the horizontal cursor keys or the
letters L and R.

Panning is controlled by use of the PAN keyword in a query sentence. If this
keyword appears either before or after all display clause elements, all columns
are panned. If the keyword appears part way through the display clause
elements, the items before it are fixed, panning only the later data columns.

Scrolling

How often have you paged down through a lengthy report and gone past an item of
interest? With the scroll feature of QM's query processor, you can move back up
to earlier pages of the report.

Scrolling is enabled by including the SCROLL keyword in the query sentence.
When running in scrolling mode, the query processor recognises the cursor up
key or the letter P to show the previous page, cursor down or the letter N to
show the next page, or a page number followed by the return key to move to a
specific page.

Automating Pan and Scroll

If panning or scrolling is required as standard for all reports, the keywords
can be included in the $QUERY.DEFAULTS VOC record.