logo
Powered by QM on a Rpi server

KnowledgeBase 00035: Panning and Scrolling in the Query Processor

Last updated: 22 Jul 2016
Applies to: All versions
Search  
Top level index       Full Index Search Tips
Previous article     Next article

This article was originally published as a Tip of the Week.

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.


Related Articles

None.



Please tell us if this article was helpful
Very     Slightly     Not at all
Comments
Email (optional)