In Report Studio, can you control the static choices that show in a value prompt based on a data item value in one of the report queries? For example if my sales rep is a "director" or above they will see "a", "b", "c", "d" in the value prompt else they will only see "a" and "b"?
NO, but you can have 2 Prompt Controls, 1 with choices A, B, C, D (PC1) and other with just A and B (PC2).
Then use a condition that checks the user's position level, for use as a Render Variable on the Prompt controls to display the correct 1, and only 1.
Example;
If Position Level Dir or above, Render PC1.
If Position Level < Dir , Render PC2.