Weird output with associated field

[Jeff Harrison]

--- Boaz Bezborodko <boaz at mirrotek.com> wrote:

[snip]

> OK, I found out that the problem occurs when I use
> indexing to go 
> through the sort/selection processing to speed up
> the operation, but I 
> still don't know why.
> 
> I execute rreport with a -io ('o' index is on the
> invoice date field 
> '20').  I then ask for the beginning date (dummy
> field 'ba') and ending 
> field ('bb').  I then use this to jump to the first
> record:
> 
>  32  -------   -   -   -   -   -   -   -   -   -   -
>   -   -   -   -   -   -
>        ? 
> If:                                                 
>                  ?
>        Then: lookup -  k=ba   i=O 
> -bg                                          ?
> 
> The selection processing then looks like this:
> 
> 33  -------   -   -   -   -   -   -   -   -   -   - 
>  -   -   -   -   -   -
>       ? 
> If:                                                 
>                  ?
>       Then: 
> ai(10,mdyy/,g)="12/31/2050"                         
>              ?
> 34  -------   -   -   -   -   -   -   -   -   -   - 
>  -   -   -   -   -   -
>       ? If: 
>
'---------------------------------------------------------
>        ?
>       
> Then:                                               
>                    ?
> 35  -------   -   -   -   -   -   -   -   -   -   - 
>  -   -   -   -   -   -
> SELECT ? If: 20 gt 
> bb                                                  
>        ?
>       Then: lookup -  k=ai   i=O 
> -bg                                          ?
> 36  -------   -   -   -   -   -   -   -   -   -   - 
>  -   -   -   -   -   -
>       ? If: ag ne "" and ag ne 
> 17                                             ?
>       Then: 
> END                                                 
>              ?
>  37  -------   -   -   -   -   -   -   -   -   -   -
>   -   -   -   -   -   -
>        ? If: MID(30,"1","13") eq "Keyoffs check"  
> 'Keyoff checks should 
> not be>
>        Then: 
> END                                                 
>              ?
>  38  -------   -   -   -   -   -   -   -   -   -   -
>   -   -   -   -   -   -
>        ? If: 20 ge ba and 20 le bb and aa="" and 19
> ne 
> "AD"                    ?
>        Then: 
> SELECT                                              
>              ?
> 
> This selects every record with '20' within 'ba' and
> 'b'.  Even the 
> record I'm missing gets selected for the first
> associated field in the 
> record.  But the second associated field never shows
> up even though 
> other records with something in the second
> associated field get printed.
> 
> The Sort for the output file looks like this.
> 
> ???????????????????????????????? Field list
> ???????????????????????????????
> ?  1- VENDOR NAME (RANDOM 11- CHECK NUMBER (ALPHA
> 21- due date            ?
> ?  2-        address 1 (r 12- VOUCHER NUMBER     
> 22- address line 3      ?
> ?  3-        address 2 (r 13- discount base      
> 23- VENDOR NAME (RECENT ?
> ?  4-        city         14- terms    (days)    
> 24- date units received ?
> ?  5-        state        15- discount (days)    
> 25- sales tax code      ?
> ?  6-        zip          16- discount percent (%
> 26- taxable amount      ?
> ?  7- code for memo       17- VENDOR NUMBER      
> 27- remarks             ?
> ?  8- CHECK NUMBER (NUMER 18- invoice amount     
> 28- date posted         ?
> ?  9- date paid           19- invoice or debit me
> 29- customer ship-to (f ?
> ? 10- CHECK AMOUNT        20- invoice date       
> 30- INVOICE NUMBER      ?
>
???????????????????????????????????????????????????????????????????????????
>                     =A2
>    ??????????????????????????? Sort definition
> ?????????????????????????
>    ?                                                
>                   ?
>    ?     Sort Field:  61 ?  A1)?  1  ?  28 ?  9  ?  
>   ?     ?     ?   ?
> ---?         Length:    0?    5?   30?    8?    8?  
>   ?     ?     ?   ?
>    ?     Descending:     ?     ?     ?     ?     ?  
>   ?     ?     ?   ?
>    ? Subtotal Field:    f?    x?    x?     ?     ?  
>  

I'm guessing the lookup dash is killing your sort. 
Why don't you try adding the appropriate sort commands
in the -v processing?

Good Luck

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHImport and JHExport. The fastest and
easiest ways to import and export with filepro. 


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ