prompt

building semantic layer
1

Hi All,
I have one requirement to create one conditional prompt where user can enter the location number for different conditions
for example :
location number < input data
locatio nnumber > input data
location number = input data
please suggest me

Thanks

bindasguy (BOB member since 2006-07-11)

2

Hi bindasguy,

You may find this older post useful:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks for response.i want the prompt like this .please advice me.
prompt.doc (29.0 KB)

bindasguy (BOB member since 2006-07-11)

4

You have to implement it using VBA macro code.

BO_Chief :us: (BOB member since 2004-06-06)

5

bindasguy,

case
	when	table.column < @Prompt('input data',,,,) then '<'
	when	table.column > @Prompt('input data',,,,) then '>'
	when	table.column = @Prompt('input data',,,,) then '='
end = @Prompt('Operator (< > =)','A',{'<','>','='},mono,constrained)

Hope this helps,
Johan

JdVries :netherlands: (BOB member since 2006-02-06)