on 10-19-2007 3:16 PM
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--
AAA--
BBB--
BBB--
DDD--
EEE--
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.