Prompt Help needed!!

building reports webintelligence
1

Hi All,
I should have a Prompt for the Project_ID object in the report(No universe prompt exists for this) which is number. I can do this at report level as by placing the object in the Filter Pane and set it as prompt.
But my problem is I should check for the length of this of the Prompt when user inputs the value and it should be greater than 5 or else should not accept.

How can I achieve this?

GNK_BO (BOB member since 2007-07-17)

2

Good Day,

in your report try filtering the inputs using UserResponse() function then have a cell who will hold the message for your filter.

if theres other work around for this it would be much appreciated. :smiley:

Regards,

-John Vincent

jvmauricio :philippines: (BOB member since 2009-08-03)

3

Hi jvmauricio,
Thanks for your reply.
I was checking if that is possible while we select the prompt itself and not to check after the user has entered the value.
Basically my intention is to check the condition at the time when user enter the prompt values.

So please help me with that.Thanks again for your reply.

GNK_BO (BOB member since 2007-07-17)

4

You can’t check that as BO doesn’t support it once the user enters, but you can restrict the values in LOV by editing the LOV query and make the prompt definition to have CONSTRAINED instead of FREE.

Jansi :india: (BOB member since 2008-05-12)

5

Hi Jansi,
I am working on BO XI 3.1 SQL SERVER 2005.
Thanks for your reply.
Are you suggesting to make that object as a prompt in the Universe itself.
But my requirement is to do it at report level only.

I was thinking of another work around. When I place the object in the query filter pane and set it as prompt. Select the Prompt Properties, there we have option as Select only from List.

My main idea is by this way we will not allow user to type in the value,but only to select for LOV. So that will eliminate the problem of users manually entering the Project ID length less or more.

GNK_BO (BOB member since 2007-07-17)

6

This is the easy way to do for your requirement.

Arjun (BOB member since 2008-07-28)

7

Hi Arjun,
Thanks for your reply

GNK_BO (BOB member since 2007-07-17)