Skip to Content
0
Former Member
Oct 19, 2007 at 02:16 PM

Variable Restriction help

24 Views

Hi Experts,

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

values.

Example

Data target will have these values.

Project Type-project no-manager

AAA--


10000001-John Wilkinson

AAA--


10000258-David Keat

BBB--


11450008-Miller Wayes

BBB--


18975620-Raju.A

DDD--


25252525-Vinod P

EEE--


45898785-Krishna

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