September 27, 2005 at 1:21 pm
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
September 27, 2005 at 1:26 pm
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.
September 27, 2005 at 1:33 pm
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
September 27, 2005 at 2:27 pm
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.
September 27, 2005 at 2:40 pm
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!
September 27, 2005 at 2:51 pm
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