Item Listing in Quiz
Deskin, Bob
Bob.Deskin at Cognos.COM
Tue Feb 5 14:42:39 CST 2008
It probably needs SET NOHEAD as well.
Bob
-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Guy Werry
Sent: February 5, 2008 3:31 pm
To: powerh-l at lists.sowder.com
Subject: FW: Item Listing in Quiz
I'm forwarding Ken's response, as it looks like he only sent it to me.
This looks like it could work (I did NOT try it); furthermore, a person
should be able to take the output from QSHOW and manipulate it to come
up with something like this.
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: Ken Langendock [mailto:Ken at Langendock.com]
Sent: Tuesday, February 05, 2008 2:14 PM
To: Guy Werry
Subject: RE: Item Listing in Quiz
Couldn't you just put a skip 1 tab 1 before each field and replicate the
field name into a title?
set page length 0
report &
skip 1 tab 1 "Field1" Field1 &
skip 1 tab 1 "Field2" Field2 &
skip 1 tab 1 "Field3" Field3
A little tedious, but should work.
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Guy Werry
Sent: February 5, 2008 2:44 PM
To: powerh-l at lists.sowder.com
Subject: RE: Item Listing in Quiz
REPORT ALL in Query sounds like the most logical thing. Perhaps
something with Suprtool?
If you were to do it in Quiz you would have to force a line feed after
each field. We use Unix and I'm sure that you could set the report line
up so that a line feed (carriage return) could be hard-coded after each
field, but you'd wind up with problems very quickly with the page width.
Thinking about this, it was almost certainly a different tool. I did
something like this recently using SQL and Oracle and it was a
NIGHTMARE.
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com] On Behalf
Of Johnson, Tracy
Sent: Tuesday, February 05, 2008 1:29 PM
To: John Stires; powerh-l at lists.sowder.com
Subject: RE: Item Listing in Quiz
Fifty/Fifty of one of the two below:
She was probably using QUICK (ala QDESIGN) followed by a GO and not
Quiz.
Otherwise she was probably in QUERY using a REPORT ALL after a FIND.
(REPORT ALL in QUERY seems similar to Quiz doesn't' it?)
> -----Original Message-----
> From:
> powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sowder.com
> [mailto:powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sow
> der.com] On Behalf Of John Stires
> Sent: Tuesday, February 05, 2008 2:23 PM
> To: powerh-l at lists.sowder.com
> Subject: Item Listing in Quiz
>
> I just had a meeting with my manager who had an interesting request.
> She had someone working for her a while back that had a way, in QUIZ,
> of listing the field name with the contents of that field immediately
> after the item name on the same line; like a verical listing. She is
> looking to avoid records with lots of fields wrapping aroung and
> missing the field names that go with the data. This guy told her that
> this was a function within PowerHouse. It turned out looking
> something like this:
>
> Branch_ID 01
> Location Chicago
> Type Sales
> Branch_ID 02
> Location St. Louis
> Type Sales Support
>
> I played around with it a bit, but could not find anything that would
> even come close accomplishing this. I could write a .COM file that
> might do the trick by capturing the fields from a QSHOW listing, but
> she says that it was supposedly all within PowerHouse. We are running
> 7.10.G1 on OpenVMS 8.3.
>
> Can anyone out there offer me some help?
>
> Thanks,
> pencarver
> John Stires
>
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
The information in this e-mail and any attachments is confidential and
may be subject to legal professional privilege. It is intended solely
for the attention and use of the named addressee(s). If you are not the
intended recipient, or person responsible for delivering this
information to the intended recipient, please notify the sender
immediately. Unless you are the intended recipient or his/her
representative you are not authorised to, and must not, read, copy,
distribute, use or retain this message or any part of it.
--
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
The information in this e-mail and any attachments is confidential and
may be subject to legal professional privilege. It is intended solely
for the attention and use of the named addressee(s). If you are not the
intended recipient, or person responsible for delivering this
information to the intended recipient, please notify the sender
immediately. Unless you are the intended recipient or his/her
representative you are not authorised to, and must not, read, copy,
distribute, use or retain this message or any part of it.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
More information about the powerh-l
mailing list