Question about printing with associated fields

Boaz Bezborodko boaz at mirrotek.com
Thu Sep 21 07:44:13 PDT 2006


Kenneth Brody wrote:


>>Quoting Boaz Bezborodko (Tue, 19 Sep 2006 14:46:29 -0400):
>>
>>  
>>
>  
>
>>>>Kenneth Brody wrote:
>>>>    
>>>>
>>    
>>
>>[...]
>>  
>>
>  
>
>>>>>>Add a minor sort on A1 (or A7 or any of the A group) and place A1 and
>>>>>>A7 on the report.  They will now refer to the corresponding entry in
>>>>>>the record.
>>>>>>
>>>>>>      
>>>>>>
>>>      
>>>
>>>>But what if A1 has is blank and A7 has an entry.  This might happen if a
>>>>check pays off one invoice, but references 3 deductions.  Will only the
>>>>A1 with an entry print leaving the other A7s out of the report?
>>>>    
>>>>
>>    
>>
>>
>>Correct.  If you sort by A1, then only the non-blank A1's (or just
>>the first, if all are blank) will be included.  Also, from this
>>description, I take it that order is significant?  In that case,
>>this wouldn't work, anyway, as you would get them in sorted order,
>>and not the order in which they appear in the record.
>>
>>--
>>KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
>>http://www.hvcomputer.com
>>http://www.fileProPlus.com
>>
>>  
>>
>  
>
Order isn't really significant here.  I just want to make sure that all
instances of A1 and A7 are printed.

What happens if I sort by A1 and then A7?  Will all instances be pulled
and show up on the report?  Will they be pulled multiple times for the
same @AF?  And, finally, can I do what I was thinking about with going
through @AF and using the PRINT command?

Boaz

**************************************************

I answered my own question after running a test so I'm putting it here for those who want to know what happens when you put two associated fields in the sort.

If there are two entries in A1 and 7 in A7 and A1 then you get 14 lines.  The first seven are all duplicates of the first line and the next seven are all duplicates of the second line.  So what it does is repeat each A1 entry as many times as it has A7 entires, but keeps the @AF stagnant with each A1 sorted iteration.

It looks like U have to use variables and arrays for this one.

Boaz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060921/b96489e9/attachment.html


More information about the Filepro-list mailing list