Jump to content


Photo
- - - - -

Report


4 replies to this topic

#1 Eire03

Eire03

    Member

  • Members
  • PipPip
  • 14 posts

Posted 23 October 2003 - 03:57 PM

Hi,

I’m having problems with a report in version 4 AIX.

In my report two files are read so that we only get client_ID’s that are originally in one file and then in the next and after that we select a field from that 2nd file, as it is equal to the key in a 3rd file. There we select only policies that are marked as 'Y' in a certain field. This goes on till char 6, just selecting clients with specific characteristics that are marked in different files.

My report seems to do this fine but somehow it only picks one client rather then all of them. When it gets to char 6, where I get just a name, I read from 6 to 6 th field which is the field for the name, char 7 from field 7 to 8 where I read a file to get an amount value then in char 8 I get the key for another file in char 9 in which I get another value and so I read from 8 to 8, the last field.

Am I doing any of these wrongly? Because I only get one single record all the time and I know there are several...

I know my explanation might be an exercise to the imagination but I’m not sure how better to explain what I’m doing…

Cheers

#2 Bradley Marshall

Bradley Marshall

    Newbie

  • Members
  • Pip
  • 6 posts
  • Gender:Male
  • Location:Melbourne

Posted 24 October 2003 - 01:45 AM

Forgive me if I point out the obvious, but is the One Time flag set to 'Y'?

Failing that all I can think of is you may need to be embedding your LS's where the file reads are done.

Hopefully that helps.

Brad

#3 Eire03

Eire03

    Member

  • Members
  • PipPip
  • 14 posts

Posted 24 October 2003 - 11:08 AM

Hi Bradley,

I don't have my One Time flag set to 'Y'.

I have put UMSG's in every char and logic and it seems to be doing everything well, I can see all the variables that I have in each char and the selection criteria seems to work. It's almost like in the end it just doesn't print anything into the .txt file that comes out of running the record.

#4 Eire03

Eire03

    Member

  • Members
  • PipPip
  • 14 posts

Posted 24 October 2003 - 11:10 AM

And sorry but I'm not sure I understand what do you mean by 'you may need to be embedding your LS's where the file reads are done' ?

#5 Eire03

Eire03

    Member

  • Members
  • PipPip
  • 14 posts

Posted 24 October 2003 - 12:56 PM

Thanks George fo the help.

I was indicating in the fields to increase 1 LINE but I was doing it at a field which I wasn't reading every time a new record was being added so it kept overidding the previous one reason why in the end I could see only one record. :ermm:

Cheers.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users