type-in prompt accepting multiple values

[spicysudhi]

hi

i'm trying to get user input for a character column filter in report with a type-in prompt. since the table got millions of records, i cannot go for the pick-list kind. But i want to allow the user to input multiple values separated by commas.

my database si oracle. how should i specify the filtering condition?

i cannot user like PARTNO IN (?PARTNO?) bcoz my part number can be similar like ABC, ABC123,... If user inputs ABC123 then my codition return ABC also. the function INSTR also i tried but fails bcoz of this condition.

thanks,
sudhi

 

[GilMerc]

Hi sudhi,

I thing it's impossible to do this directly in Impromptu particularly if a table contain a million of records.

But you can use a macro. In this case, you can use a methode openreport with a parametre that contain multiple values separated by commas.


Gilles.

 

[spicysudhi]

thanks for the reply.

im generating the orders report and taking the part no as user input. since we got large number of parts its not possible to add in pick-list. so only way is to make it as user type-in. thats fine bcoz the users are well aware of the part numbers they are looking for. but if they want to see report for 2 parts, they are being forced to run report twice. i am looking for an option where user inputs parts separated by comma and the filter works accordingly.

regards,
sudhi

 

[GilMerc]

Sudhi,

I repeating what I said in my last post, you MUST develope a macro that open a dialog box that contain a text box where a user enter a list of part no. After this, you must decrypt a list or you pass a list directly in a parameter of a report.


Gilles.