Headings for a subfile

[arthur kogan]

Hi Max,

if all your subfile fields are ascii (which would be a reasonable assumption,
since you are transferring it to a spreadsheet), why not use QTP and have a
pre-pass where you output a single record  with headings as field values "at
initial", then have your normal pass with "append" option on the subfile.
Obviously you should add your field separators as per normal.

for example:

request pre-pass
acc somefile

define myfield1 char* = "myfield1 heading"
...
...

subfile mysub portable keep at initial &
include myfield1, ...

request main-pass
acc myfile

...
...

subfile mysub portable keep append &
include myfield1, ...



I hope this helps.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia


MaxButen wrote:

> How to get headings for the fields in a subfile?  When I FTP the subfile
> to a spreadsheet, I have to add the headings manually.  I've tried
> REPORT HEADING but that outputs the heading to my terminal, which is
> useless. Using version 7.09.
>
> Here's a sample -
> ACCESS SOMEFILE
> SET SUBFILE NAME SUBNAME KEEP
> REPORT SUMMARY NAME ADDRESS ETC...
> --
> Max Buten - Powerhouse Programming Consultant - maxbuten@home.com  (610)
> 664 2301
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.