Skip to Content
author's profile photo Former Member
Former Member

Parameters not from database

Hi,

I want to have a few parameters in my report that does not come from the database. Those parameters are numeric numbers with possibly a fraction.

How can I define a report parameter that does not come from the universe?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2009 at 09:49 PM

    Hi Patrick,

    This is not possible in WebI. However, you can define a prompt in the universe that does not link to a db.

    Option 1

    Create an object with a prompt in it.

    @prompt('select number','N',{0,1,2,3},mono,free)

    If you bring this into you results you will be prompted for the value without a restriction on the db. You can get the value returned in the UserResponse function.

    Option 2

    Create a condition that always evaluates to true

    my_field = 
    case 
    when @prompt('select number','N',{'0','1','2','3'},mono,free) = 0
    then my_field
    else my_field
    End

    Hope this helps

    Alan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.