Cascading dynamic parameter - multiple Level 2

[spedi]

I need to create dynamic cascading parameter with multiple level 2 parameters. For example;

Say we have

Level 1 - Living things
level 2 - Birds
level 2 - Animals
level 2 - Fishes
etc.

Can this possible?



Srinath

 

[IdoMillet]

Do you mean single-value choice for level 1, but multi-value choice for level 2? Where exactly is the problem?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[spedi]

Let me take a common example to explain my situation:

Country--> Region --> City

level 1 --> level2 --> level3


In the typical scenerio Region values get filtered based on Country selection; and city selection gets filtered based on Region.

In my situation it is as follows

Country --> Region
--> City

Level 1 --> Level 2
--> level2



My list of values for Region
and City should directly be based on Country selection not in a hierarchy as explained in the first example.

By selecting Country as USA

Regions should list Northeast, Southeastt, Western etc.
Cities should list San Jose, New York, illinious, etc.

Thanks


Srinath

 

[IdoMillet]

As far as I know, this can't be achieved with Crystal alone. However, consider 3rd-party Crystal tools (see list at:

http://www.kenhamady.com/bookmarks.html).

My DataLink Viewer provides its own implementation of dynamic and cascading parameters (applying even to Crystal versions before Crystal XI). It can provide the type of logic cascade you are looking for by virtue of sharing the values of already answered parameters (provided they are named the same) across different hierarchies.

So you would create:
Country --> Region
Country --> City
but DataLink Viewer will prompt for Country only once and use the value(s) for both the Region as well as the City stages.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com