how to move fields in a report program column by column

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

The requirement is I have to read an input file, check for some if condition
and if the condition is satisfied I have to populate this report column by column.
The detail information on the report will load in a column by column fashion beginning with the first column and will only proceed to subsequent columns if the number of detail entries dictate.(As per my specs)

I would like to know how to move the fields, how do I check for the EOF column, EOF page.
what other things are to be looked into. I have not been into coding anytime prior to this. I might come up with some very basic queries,

QS QS QS QS

XXXX XXXX XXXX XXXX
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX XXXX
XXXX XXXX XXXX
XXXX XXXX XXXX

Thanks
Manjusha

murmohk1 · Posted: Tue Sep 11, 2007 12:32 pm

Manjusha,

Provide some examples for better understanding. Your requirement is not clear.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

Thanks Murali,

I have to write a program which also has a report program. The specs tha I got says I need to populate the report column by column as i mentioned in my prev mail....oops looks like the alignment of my query changed in my post. QS is the field name of the report. There are 4 such field. After reading a flat file and based on some conditions I need to populate the fields.

let me know what kind of info do you need. Being new to it, I guess I am not able to put the query in a good order.....

Regards,
manjusha

murmohk1 · Posted: Tue Sep 11, 2007 12:49 pm

manjusha,

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

Are we allowed to attach the spec in this forum.....

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

Manjusha,

Welcome to the forum. Please read the forum rules before posting anything on the forum. This is very important.

u r nt supposed to put the company docs on the forum. this will disclose company confidential things to public which company may not like. In worst case company may sack you. this only for ur information. u can ask moderator to remove the link frm the forum.

Explain your problem/query in short using some dummy data which helps members to understand the problem u r facing and give u solution on that.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

Thanks sandy for the info

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

Hi,

u can display the data columnwise in simple way.

define the cols in the WS section and move the data in the particular condition loop and write after moving that record.

like

01 REPORT.

03 COL1 PIC 9(2).
03 FILLER X(5).
03 COL2 PIC 9(2).
03 FILLER X(5).
03 COL3 PIC 9(2).

in conditional para.

MOVE 01 TO COL1
MOVE 02 TO COL2
MOVE 03 TO COL3

WRITE REPORT.

I think this solve ur purpose.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

Hi,

Thanks a lot for your quick reply.

I had requested the moderators to remove the Specs.I can still see it:)

coming to my query, since it is report pgm, I wanted to know wud my pgm make sure that we have finished populating one column and get to the next column, so on and so forth...

Regards,
manjusha

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

hi,

I think what you are asking is not satisfying the coding standar of cobol.I guess if you are asking like..

suppose

empname no. add
a
b
c
i mean to say if you are asking to populate first column totally and then move to next column .is it like that?

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

hi Manjusha,
I think after reading the input file,Based on some condition you have to move 1st records or datas of specific column and then you can perform on
the second record and so on .I don't think you first populate the one
column then move to second and so on.Am i clear to you?

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

Thanks for your reply,

yes I need to populate the first column and then thenext column so on and so forth. I have four such columns....

what I had been thinking was reading the input file if the condition is satisfied I shall move the reqd record to a W.S.S variable say Q1S1 and then read the second record move it to Q2S2 and so on....and when Q4S4 is moved I will write the record.

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

Hi,
if i got your reply correctly as i said you have to perform operation on the
first record and then can move on to the second record.
like after reading the first record move the data in the corresponding ws variables Q1S1 to Q1S4.
And then write the record.afterward read the second record and perform the operatin.I think
you are more confused with the cobol coding than to requirement.Why are you confusing yourself to populate the first column then second and
so on.
see you can perform operation only on the record you are reading.
i guess you are clear with what is a record is in a cluster or file?

Am i clear to you.Base line is that You can perform operation on the
record which you have read that time.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

thanks a lot....

I am confused with requirement as well as the cobol coding I guess:)

My requirement is to ....my report will load column by column

The detail information on the report will load in a column by column fashion beginning with the first column and will only proceed to subsequent columns if the number of detail entries dictate.(As per my specs) [/quote]
.....since it will load column by column I cant write it unless a page is complete...isn't it...

looks like I am confused and confusing others as well....

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

Above logic will write all the cols at a time, so not worry abt individual cols

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

I think reports are never written like wht u demand.

they are processed account by account and all the cols are populated at the same time otherwise ur program will not be of any use if u are trying to populate whole cols at a time this is bcoz:

1. Program has to process all A/C's for each col.
2. In that case u need to store all the results in the array or something which will consume unnecessary space and time.
3. Total job will take lot of time and space which is not permissible.

Try to figure out exact req and code it with less effort and generalize way.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

thanks so much......I shall try to do it the way you suggested. The mainframe link is down for now:)

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

are your input files are more than one.

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

hi,
i am absolute agree with Help-Me-Out.That is what i am trying to explaining you.Dont bother about column,Process on each record.if required i can give u smail example.

dick scherrer · Posted: Tue Sep 11, 2007 7:41 pm

Hello,

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

It's actually a simple reprt program( though not that simple to me:)

)

I have to read a file and based on some conditions i have to write. The report has two colum fields say Quality style and irregular style each with pic(7) with a space. So in all it takes 15bytes. In order to cut down on the size of this report I have to place multiple images (columns) of the data across the physical page. The detail information on the report will load in a column by column fashion beginning with the first column and will only proceed to subsequent columns if the number of detail entries dictate.

I tried writting the report and feel I can manage writting it but my problem lies in the fact that I do not how do I put the things supposed to be in the next page as one more column in the 1st page itself and so on till 4th page.

Regards,
Manjusha

I have been thinking of alternatives, I feel I need to define an array. Read my input file and load my table and write the report by taking it from the table....... wonder if this will work....

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

hi manjusa,
well i think first u short the file you are reading and remove the duplicate
data if i am getting your question right.You have to design your
report layout in RD.If you want your page let say contain 16 records
design your report format in such a way.Or if you are using only
FD you have to do it by the logic.

But again why are you thinking again column wise.Its record miss not
column you have to read.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

thnks purnendu...

wat I want is after the page is populated, I need to populate the next page. right....But in the report my 1st page shud contain report of 4pages

for this I need an array of 2 dimention.

like say
Q1S1(Of the 1st page) Q2S2(of 2nd page) Q3S3(of3rd page) .....

coming in together in 1 page....

looks like my client wants to save on paper:)

Purnendu.it · New User Joined: 11 May 2007 Posts: 57 Location: chennai

hi manjusha,
but u tell me how one can have records of three pages in 1 page.i hope
u are able to get it.can u provide some sample data for better clearification.

manjusha.singh · New User Joined: 14 Jun 2005 Posts: 16 Location: bangalore

I am really breaking my head on it....

actually, my report wud have 2 fields each with pic 7 with a space in between.....that way I am left with 132-15=117. I want to use the next 15bytes to have record of second page and so on.....I think I am not able to explain the requirement......

Thanks a zillion for the help.I have been a member of this forum for quite sometime but never posted anything untill yesterday. It really feels good that there are so many ppl to help. Thanks all.....