MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Header only for first page of report created using ezytrieve

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
chikdu
Beginner


Joined: 06 Jul 2005
Posts: 29
Topics: 20

PostPosted: Wed Jul 25, 2007 5:44 am    Post subject: Header only for first page of report created using ezytrieve Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Wed Jul 25, 2007 7:05 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
chikdu
Beginner


Joined: 06 Jul 2005
Posts: 29
Topics: 20

PostPosted: Thu Jul 26, 2007 3:47 am    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Thu Jul 26, 2007 7:02 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
chikdu
Beginner


Joined: 06 Jul 2005
Posts: 29
Topics: 20

PostPosted: Fri Jul 27, 2007 6:15 am    Post subject: Reply with quote

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
View user's profile Send private message
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Fri Jul 27, 2007 6:31 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group