I have a requirement where in the query when the Variable screen popups
i want to restrict the selection values it offers so that instead of
all the values from the data target it only display certain character
Data target will have these values.
Project Type-project no-manager
from the above values i have reports based on Project Types
like for example when i am having a report on project type AAA and i have a variable
on Manager, so when the variable popups i want it to show only two values like
John wilkinson and David Keat not all the managers.
How can i achieve this (here i have given the data for example in real i have around 1000 managers with 15 project types.
can i achieve this .
thanks and regards