Hi:
I need to write the detail data on a report to an external file, so it can be used in a spreadsheet. Basically, converting a report to a database file (without totals or subtotals).
Had to get involved in some old code. I'm using to seeing an EXCPT DET statement, where I could put a WRITE statement to send the same data being printed to an output file..
This program is using a D spec for detail data. There are EXCPT statements for the headings and totals, but none for the detail. Sorry for the beginner question, but how can I know where to put a WRITE statement to capture the detail being printed?
Here is a snippet of the O specs. . I'm having trouble getting a copy and paste to format properly, so sorry it looks a mess. Basically, fields CA31c, CA31CN, CA31CH, CA31CA need to be written to an external PF every time these fields are printed on the report.
I see EXCPT QHEAD and PHEAD statements in the program but cant figure out how the details are printed, so where to put my WRITE statement.
OQSYSPRT E PHEAD 03
O PROGRM 10
O TITLE1 96
O 24 'Freedom Series'
O E 78 QHEAD 1
O 8 'Customer'
O 63 'Check...................'
O 69 '......'
O 78 'Posted'
O 87 'Invoice'
O D 15 11 78 1
O 8 ' '
O D 15NLR 78 1
O CA31C 10
O CA31CN 41
O 11 CA31CH 54
O 11 CA31CA J 70
Thank you in advance for any help!
Best regards,
Ed
I need to write the detail data on a report to an external file, so it can be used in a spreadsheet. Basically, converting a report to a database file (without totals or subtotals).
Had to get involved in some old code. I'm using to seeing an EXCPT DET statement, where I could put a WRITE statement to send the same data being printed to an output file..
This program is using a D spec for detail data. There are EXCPT statements for the headings and totals, but none for the detail. Sorry for the beginner question, but how can I know where to put a WRITE statement to capture the detail being printed?
Here is a snippet of the O specs. . I'm having trouble getting a copy and paste to format properly, so sorry it looks a mess. Basically, fields CA31c, CA31CN, CA31CH, CA31CA need to be written to an external PF every time these fields are printed on the report.
I see EXCPT QHEAD and PHEAD statements in the program but cant figure out how the details are printed, so where to put my WRITE statement.
OQSYSPRT E PHEAD 03
O PROGRM 10
O TITLE1 96
O 24 'Freedom Series'
O E 78 QHEAD 1
O 8 'Customer'
O 63 'Check...................'
O 69 '......'
O 78 'Posted'
O 87 'Invoice'
O D 15 11 78 1
O 8 ' '
O D 15NLR 78 1
O CA31C 10
O CA31CN 41
O 11 CA31CH 54
O 11 CA31CA J 70
Thank you in advance for any help!
Best regards,
Ed
Comment