Force LOV Selection

[DugzDMan]

Is there a way I can force a user to make a selection from a list of values? What I really want to do is get rid of the text boxes displayed on the prompt screens.

Thanks,
Doug

 

[Sridharan]

Hi,

I don't know what you are upto!!! Do you mean the user has to select the values from LOV and not able to type something in the Textbox displayed. If so, create the prompt with the constrained option where he will be forced to select only from LOV and if the prompt is created with free option then the user can type in the Textbox.

Good Luck
Sri

 

[DugzDMan]

That's exactly it Sri, but where do I set that option??

Thanks,
Doug

 

[Sridharan]

Hi,

When you create the prompt you have to give it. Lemme give you an example

@Prompt('Enter State','A','Store\State',mono,constrained)

Parameters:-
1. Prompt Name
2. Data Type
3. Object from where to show the LOV.
4. Can take mono or multi.
a. mono only one value can be given
b. multi allows selection of multiple values. usually
used where you have a IN clause for condition.
5. This can take either constrained or free.
a. constrained - You can select only from LOV and user
cannot enter values.
b. free - User can type in the TextBox.

You must be looking at constrained option.

Hope you get a better idea.

Regards,
Sri

 

[DugzDMan]

Where are you creating the prompt? Mine were just from the reporter side so I'm not getting those options (it's all drag and drop).

 

[Sridharan]

Hi,

You do in the Designer i.e. at the Universe Level.

Sri

 

[DugzDMan]

I have an end user that just loves drop down boxes (best thing since sliced bread, I guess). Anyway, is there a way to put the LOV in a drop down and have that as the prompt, versus using the text box and values button?

Thanks for all your help!!

 

[skrandel]

Not without using the SDK.

If you build reports with WebI and use the Choose from a list option, then you can do it.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Sridharan]

Yeah in FC using SDK we can do. But as Steve if it is WebI it is there by default.

Sri

 

[DugzDMan]

Thanks Guys! I'd like them to use WebI, helps to keep everything current and appears to do what I want as a default.

Again, thanks for the help!