I was able to get the Btree.extract to work by extracting the record

keys and the totally the quantity of the records. However, when I

use the field in an Rlist statement it bombs. The field routine uses

current @ID. When the Rlist is run for one record it displays properly, but when more than one record is listed, then it shows a

skewed printout of values on the screen. Any ideas on how to fix this? TIA, Jim

Could be that the dictionary is not set for multi-values.

The Sprezzatura Group

[/i]World leaders in all things RevSoft[/i]

No, I tried setting the field to multivalue and it didn't make any

difference in the output. The message I am getting

is "Searching Cross References….Print Report..". I tried creating

a replica field and setting the variable RECNO to @RECORD and also tried the field name, SUPPLY.NO, instead of @ID.

Otherwise, the field is super fast and works perfectly when brought up in a window…

Jim.

Could you post the code from your symbolic and let me know what ver of AREV you're on? Thx.

Larry

[email protected]

Here's the code…Jim

ID=';QUANTITY =';TOTALAMOUNT=';ITEM=';HITS=';SUPPLY_ID=';DATESHIPPED=

DATE=';OPERATOR='

RECNO=@ID

DATESHIPPED=OCONV(DATE() - 71,"D2-")

OPERATOR=]"

DATEPREF=OPERATOR::DATESHIPPED DATE=OCONV(DATE(),"D2-") REC=@RECORD ID=@ID DIC=@DICT OPEN 'INVENTORY_SALES' TO INVENTORY_SALES ELSE STOP 'UNABLE TO OPEN INVENTORY_ OPEN 'DICT','INVENTORY_SALES' TO @DICT ELSE PRINT 'CANT OPEN D.INVENTORY_SALES HITS=' CALL MSG('Variable Value is: %1% ','A',,DATEPREF)

SEARCH.STRING=SUPPLY_NO':@VM::RECNO::@FM:"DATE_SHIPPED":@VM: ':DATEPREF

CALL BTREE.EXTRACT(SEARCH.STRING,"INVENTORY_SALES",@DICT,HITS)

FOR X= 1 TO COUNT(HITS,@VM) + 1

ISREC=FIELD(HITS,@VM,X)

   READ @RECORD FROM INVENTORY_SALES,ISREC ELSE GOTO DONE ;* LOOP

   QUANTITY=@RECORD

   TOTALAMOUNT=TOTALAMOUNT + QUANTITY

NEXT X

DONE:

@RECORD=REC

@ID=ID

@DICT=DIC

@ANS=OCONV(ICONV(TOTALAMOUNT,"MD2"),"MD2")

Larry, Version 3.11

Jim,

Did you delete the quotation marks within the search criteria, per Warren's response to your later posting?

Bill

So this "Searching Cross References…." is showing up all over the place in the report?

This has to do with the status line, which you cannot update whilst using the viewer. Try passing an S to supress message.

The Sprezzatura Group

[/i]World leaders in all things RevSoft[/i]

Yes, and now it works… Thanks for the help. I thought I had tried

every variation…Jim

Here's what worked.

DATESHIPPED=OCONV(DATE() - 60,"D2-")

OPERATOR=]"

DATEPREF=OPERATOR:DATESHIPPED

SEARCH.STRING=SUPPLY_NO':@VM::RECNO::@FM:"DATE_SHIPPED":@VM:DATEPREF:@FM

Thanks again.

View this thread on the forum...