Page 1 of 1

Easytrieve Report Doubt,please clarify

Posted: Fri Jun 27, 2014 8:33 am
by charigln
Hi,

I need code for accomplishing below requirement...Below is my report

REPORT 05 MY QUERY MODULE - title1
REMARK LIST - title2

SNO ACCT NO ERRORS - line1
1 564535 ACCT NUMBER NOT FOUND - line2

I want this first line (SNO ACCT NO ERRORS ) to be printed once on every page

I want second line(1 564535 ACCT NUMBER NOT FOUND) to be printed repeatedly.

Hope I am clear. Do provide the code.

Regards,
Chari

Posted: Fri Jun 27, 2014 1:29 pm
by William Collins
So, title1, title2 and line1 are the TITLEs. line2 is the LINE. What problem are you having?

Posted: Fri Jun 27, 2014 8:41 pm
by pawan1986
You can keep SNO ACCT NO ERRORS in the HEADINGS instead of LINE1 and the values as Line 1

so that headings will print on every page only.

Posted: Fri Jun 27, 2014 8:46 pm
by pawan1986
TITLE 1 ' REPORT 05 MY QUERY MODULE'
TITLE 2 ' REMARK LIST'

HEADING WS-SNO ('SNO')
HEADING WS-ACC-NO ('ACCT NUMBER')
HEADING WS-ERRORS ('ERROR')

LINE 1 WS-SNO +
WS-ACC-NO +
WS-ERRORS

you have to move the values for the WS fields in the JOB activity before you print
so that the HEADINGS will print once on every page.

Posted: Mon Jun 30, 2014 1:53 pm
by charigln
If we use a Title instead of Line then there will be a space line introduced by default which is not required in my case...If I use Title, Report will look like below...

REPORT 05 MY QUERY MODULE - title1
REMARK LIST - title2

SNO ACCT NO ERRORS - Title3

1 564535 ACCT NUMBER NOT FOUND - line1

Is there a way to supress this space line between Title3 and Line1 ?????


Regards,
Chari

Posted: Mon Jun 30, 2014 3:11 pm
by William Collins
Have you got a manual? If not, get one. Read up on the REPORT statement and its many and varied options.