Can you use a member set as a static prompt choice ?

[MikeG]

I have created 2 data items in the query as member sets

Cars   set (car A, car B, car C)

Other Cars (set (car X, car Y, car Z)

The user wants a report with a prompt where he can select one of the 2 membersets.

I put in a value prompt, opened a new static choice, it wants a Mun value in the Use box and the membersets don't have Muns , what can I do ?

thanks Mike

[BigChris]

Have you based your value prompt on a query? If you just want to make the user choose either "Set A" or "Set B" then it doesn't need a query behind it.

[MikeG]

Hi,

Yes in the query I added the Car type = ?parameter1?  otherwise without a query it would not be able to pull back the 10 columns of data relating to the picked memberset

[rockytopmark]

1. Change Value Prompt to NOT be associated with a query
2. Add 2 static values: 
  -  Use: C, Display: Cars
  -  Use: O, Display: Other Cars
3. Create a data item for the row edge in the layout
case
when ?pParameter? = 'C' then set(car1, car2, etc)
else set(carX, carY, etc)
end

[BigChris]

Thanks rockytopmark - that's what I was driving at (no pun intended), but I didn't have time to properly elaborate.

[MikeG]

Thanks guys

worked a treat, job done