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
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.
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
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
Thanks rockytopmark - that's what I was driving at (no pun intended), but I didn't have time to properly elaborate.
Thanks guys
worked a treat, job done