I'm attempting to create a report in query management that will hopefully look something like this.....

ATM Watch Notification Log
Terminal Incident Date Time Method Contact
-------- ---------------- -------- -------- ------ ----------
1234 I000000000004137 09/01/09 10:27:39 Joe Smith
Communication Lost
1234 I000000000004137 09/01/09 10:27:53 Joe Smith
Down too Long
1234 I000000000004137 09/01/09 10:28:08 Bill Jones
Communication Restored

With the Page heading and column headers repeating at the top of each page.

Unfortunately, that's not the result I'm getting. When the query is run I end up with only the page heading on page one. Page two then prints as I expect with the page heading centered at the top then column headings, and then data. Page three prints with no page heading or column headings just the detail. Then Page 4 prints like page one with only the page heading and nothing else. This pattern repeats to the end of the report.

Here is the screen shot of the page heading in work with query manager report forms

Edit Page Heading

Type choices, press Enter.
Blank lines before . . . . . . . . . . . . 0 0-999
Blank lines after . . . . . . . . . . . . 1 0-999

Page text: Use &col, &DATE, &TIME, and &PAGE to cause variable insertion.

Line Align Page Heading Text
1 CENTER ATM Watch Notification Log

This is the strqmqry command from my joblog

SETVAR((BEGIN '''2009-09-01''') (END '''2009-09-01''') (DEVICENO '1234')

Any help or insight would be greatly appreciated.


Emily Smith
Bank Data Services
CONFIDENTIALITY NOTICE: This email message is private,
confidential property of the sender, and the materials
may be privileged communications intended solely for
the receipt, use, benefit, and information of the
intended recipient indicated above. If you are not
the intended recipient, you are hereby notified that
any review, disclosure, distribution, copying, or taking
of any other action in reference to the contents of this
message is strictly prohibited, and may result in legal
liability on your part. If you have received this message
in error, please notify the sender immediately and delete
this message from your system. We believe that this email
and any attachments are free of any virus or other defect
that might affect any computer system that it is received
and opened in, however, it is the responsibility of the
recipient to ensure that it is virus free and the sender
accepts no responsibility for any loss or damage.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].