Parameter expert help need!!!!! 2

[Durango122]

Hi Folks
Cr9
MS sql
I need some expert on parameter here to see if this is possible.

Scenario:
i have 2 parameters 1 is ?Channel and the other is
?Territory
for ?Channel theres INS, PFS, PC,SP
for ?Territory there E1, E2, E3, E4
heres the tricky part i need your input.
--------------------------
for ? Channel PC
the ?Territory are E1, E4,

i've been ask to see if this can be done
If the user click and select ?Channel = PC
then the next selection would be the ?Territory
so the user click ?Territory parameter
he wants to see E1,E4 already selected in the window

ex: Select Channel: Pc
Territory: E1,E4

hope you understand what i've been ask to perform

Thanks





Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

Cascading parameters are only available in XI, unless you use an add-on product like Ido Millet's viewer (I think).

-LB

 

[synapsevampire]

As lb states, dynamic parameters in CR XI might handle this, providing the database is also demonstrating that hierarchy.

Anotehr approach would be to use a single parameter and define the defaultvalues within it, and one method being to use the description of the default values as the display only attribute, and for your example place:

PC->E1
PC->E4

Now take action in the record selection based on those choices.

-k

 

[JC442]

Hi There,
What you are looking for is called a cascading parameter and it is available in CR XI R2.

There may be a way to build your own cascading parameter in earlier versions, but it will take some doing.

 

[Durango122]

Hi Folks
Thanks for the input.
As i fugure v9 does not have this feature.
So in other word i would have to create a manual one
In the fund table there is is a Channel and Territory field
ex:
channel - territory
PC - E1
PC - E2
AND SO ON....
ST - W1
ST - W2
ST - W4
AND ONE.....
so my channel parameter wold have this as display value and description
value - decsription
pc ->E1
pc ->E2
pc-> E3.......and on

ST ->W1
ST->W2
ST-W3 .... and on
i would show value and description in the ?Channel paramter
and have multiple select check
so the would have to add each channel and territory where channel and territory are equal in the list
or would someone have a better way to do it
i'm open to any suggestion.
Thank's in advance

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40