Hi,

I need any idea to resolve this issue.
I created a query related to lot number.
At the query, user required to insert lot number.

so in the report, i would require the system print all lot number that look a like as lot number in the query.

so, i do not know where to start or put the logic. is it at my query? or in my report?
pls help.
tq.

Do you have a report session or just a query? If just a query in the report script you could build your code for lots the look like what was input. If it was me I would just report all lots for an item - trying to find a lot "like" what was entered could require a lot of coding.

I suppose you talk about ttadv3280 Baan query. In the query you can find the variables used as user input (on form) for the user by the query engine. These variables are declared external an can be used in your report linked to the query too. See also the answers to your other question: http://www.baanboard.com/baanboard/showthread.php?p=196945