Parameter defaults

  • Hi all,

    Does anyone know why you cannot set a "non-query" default value with a "from query" prompt? And if you can, will you tell me how?

    Thanks and have a great day, Kerrie

  • Your question is an oxy moron, can you elaborate on your question, and state what your trying to do.

    The non queried default would be "Hard Coded"

    a From Query default would be a result from a query, More dynamic.

     

  • I have a from query prompt (its own dataset), lets say a state prompt. I want it to default to Ohio. I can hard code it in. But when I go to preview I still have to select what state I need.

    Did I explain better if not let me know.

    Thank you, Kerrie

  • I think you need to change it up a little.

    For your parameter. the available values would be from your queried dataset, (All available states)

    and your default would be a non queried default of "Ohio". Or what ever your dataset is using from the available values.

    For your default to be from a query would be like, "Last Order placed" you would query for 1 id which is the last order. Etc.

  • The default value is case-sensitive and looks at trailing blanks.  If the query you are using stores the "Ohio" in a Char(15) type, you need to make your default value field look like this -->  ="Ohio           "

    Good Luck!

  • Thanks to both of you, I got it!!!!!

    I love this forum

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply