Repeated values in value prompt

[Arsenal]

Hey all,

Quick question - Suppose I had product type as a value prompt, and it had values of A, B, C and D

Is there any reason why the value prompt, during selection, would show as:

A
A
A
A
A
A
A
A
B
B
B
B

etc. when it should show as :
A
B
C
D

If I just use a filter (?producttype?) and type in a value, it works fine. But when RS prompts for a selection is when the problem is  ocvcuring

Any ideas?

[rocket]

Looks like the table you're pulling from has multiple records for each product type.  For example, if you're pulling the prompt from a fact table, you'll by default get multiple results for each item unless you ensure you have a distinct selection. 

Make sure you are using select disctinct product type from table.  You should be able to group on the product type in your query in RS assuming that is the only query item in the query and that will force a select distinct.