cancel
Showing results for 
Search instead for 
Did you mean: 

Variable Restriction help

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Sreedhar,

Try to create a user variables for Project and Manager and populate with initial values under I_STEP = 1.

<a href="http://www.box.net/shared/d05j3ngzru">Sample Code...</a>

<a href="http://www.box.net/shared/i1tmtc6stf">User Exit</a>

Hope it Helps

Srini

Former Member
0 Kudos

Hi Srinivas.

Thanks for the documents

i am bit confused can you kindly be bit clear.

like what i have understood is that i have to create two variables one for Project type and the other one for Project manager and for which do i need to write the code is it for Project manager or project type.

and what is the logic. can you kindly put the logic here

thanks and regards