View previous topic :: View next topic |
Author |
Message |
chikdu Beginner
Joined: 06 Jul 2005 Posts: 29 Topics: 20
|
Posted: Wed Jul 25, 2007 5:44 am Post subject: Header only for first page of report created using ezytrieve |
|
|
Hello All,
I have a requirement where i need to modify an ezytrieve program.
One fo the requirement being that the header should be displayed only on the first page of the report, as this report needs to be exported to an excel.
The report will have only header and detail record.
Can anyone suggest me how this can be done?
Thanks in advance,
Chikdu |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Wed Jul 25, 2007 7:05 am Post subject: |
|
|
chikdu,
Write the report as an output file and use START parm to write the header only once
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
chikdu Beginner
Joined: 06 Jul 2005 Posts: 29 Topics: 20
|
Posted: Thu Jul 26, 2007 3:47 am Post subject: |
|
|
Kolusu,
Thanks for the quick reply.But there is a problem in doing so, as this report is sequenced on some fields.
So i think we will have to print it as a report.
Is there any other way to do so in the report, so header is seen only on the first page. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Thu Jul 26, 2007 7:02 am Post subject: |
|
|
chikdu,
Why not get the headers in the excel and let your report write only the data. In your report use the parm NOHEADING and it will supress the heading. The report will have just the data.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
chikdu Beginner
Joined: 06 Jul 2005 Posts: 29 Topics: 20
|
Posted: Fri Jul 27, 2007 6:15 am Post subject: |
|
|
Kolusu,
I thought of putting the header in a file and data in another file and merging the header file and the data file in JCl. I think it should help.
Thanks!!! |
|
Back to top |
|
|
CICS Guy Intermediate
Joined: 30 Apr 2007 Posts: 292 Topics: 3
|
Posted: Fri Jul 27, 2007 6:31 am Post subject: |
|
|
Why not just print the report as if the page never ends, therefore only one page heading?
Quote: | REPORT [report-name] +
[PAGESIZE ({literal-6a} [literal-6b])]
The value of literal-6b, the display-page-size, sets the number of lines per page for REPORT procedure DISPLAY statements. Literal-6b has a valid range from 0 to 32767. If literal-6b is zero, then a DISPLAY statement considers the report page infinite in size and never attempts to determine the end-of-page condition. |
|
|
Back to top |
|
|
|
|