giving range filters and pipe filters in a gobal feild

southindian

Dear all,

i need to a suggestion from u all. i had declared a gobal variable (itemno) and linked with item table thorugh which they select the item from request form in run time. my doubt is only one item can be selected at run time in lookup field.

is it possible to apply range filters or select different item by applying pipe filter (for eg. itm1|itm2|itm3. (or) itm1..itm3) in a feild which is a gobal variable designed in Request Form.

kindly clarify my doubt by giving ur valuable inputs :-k

UdAkunuri

Hi,

You can directly find the solution for this in Base itself.

Go to Sales prices, there you have Item No filter and you can directly use that.

southindian

dude... i think u dint understand my problem..... actually. i had already the gobal variable with item table(27) for look up..... it is working.....

my problem is at a time i can select only one item n execute the report ...... but i want to apply range filters or select different item by applying pipe filter (for eg. itm1|itm2|itm3. (or) itm1..itm3)....

u got me... if am worang .... kindl guide me

UdAkunuri

Sorry, i didnt get you what you want.

Do you have global variable "ItemNo - code" or "Item - Record variable" ?

Can you tell, what is the actual requirement?

Savatage

southindian wrote:

i had declared a gobal variable (itemno) and linked with item table

I see if you linked them I don't see how you care going to do multiple items. By linked are you talking lookup?? (unclear)

setfilter("No.",ItemNo);
currform.update;

southindian

let me clearly explain u .i had designed the report by giving Item(lookup) selection in request form tab , which is done by coding(for eg. IF FORM.RUNMODAL(31, gvItem) = ACTION::LookupOK THEN BEGIN)in LOOKUP trigger.
In this I can select one item at a time.... my doubt is how to apply range filters (for eg.itm1..itm3) or select different item by applying pipe filter (for eg. itm1|itm2|itm3.
Is it possible to apply such filters?
Is there is any way by which i can apply such filters........
Kindly expecting ur valuable inputs....... :?:

UdAkunuri

UdAkunuri wrote:

Hi,

You can directly find the solution for this in Base itself.

Go to Sales prices, there you have Item No filter and you can directly use that.

This is the solution for your requirement. In that form also ItemNo is a variable and the same code you can write in request form of report tooooooo..

southindian

dear Mr. uday,

u mean to say Sales price table........ how it may help me as per requirement.....

southindian

thanks for ur valuable input Mr. Uday.... \:D/ i got ur point

UdAkunuri

Hey i am not saying about table, i am saying abt Form....

southindian

any way ... thanks for u valuable input.......

ramuguptha1

Hey guys I too had the same problem and got the solution now
thanks for the response UD . =;