One parameter depends on other??

[vshapiro]

I have a parameter {?StaffType}:

(if {?StaffType} <> &quot;All&quot; and
{PACS_PROJECT_STAFF.STAFF_ACTIVE} = 'Y' then
{PACS_PROJECT_STAFF.STAFF_TYPE} = {?StaffType}
else if {?StaffType} = &quot;All&quot; and
{PACS_PROJECT_STAFF.STAFF_ACTIVE} = 'Y' then
{PACS_PROJECT_STAFF.STAFF_TYPE} in ['01', '02', '03', '04'])

and I need to give user another one - if StaffType = '01' then {?Co_Manager}
else if '02' then {?Co_Super}.... etc

How can I do this??

Thank you

 

[IdoMillet]

Unless you are willing to use a 3rd-party tool, you would need to prompt your user for all these parameters.

In those that are &quot;optional&quot; have a default value of &quot;Ignore&quot; (this is not needed but a nice for the user).

In your record selection formula have something like:

({StaffType} = '01' AND {Co_Manager} = {?Co_Manager})
OR
({StaffType} = '02' AND {Co_Super} = {?Co_Super})

etc.

Cheers,
- Ido






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

http://www.MilletSoftware.com

 

[vshapiro]

I think I did not explain correctly.
Yes, user will be prompt to all the parameters but if user select {StaffType} = '01' he should be able to select only from {?Co_Manager}, if {StaffType} = '02' then only from
{?Co_Super})........??

 

[IdoMillet]

You can't do this with Crystal because Crystral always prompts for all parameters. For a list of 3rd-party Crystal tools see:

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

I'm aware of at least one viewer listed there that can do what you are asking for (cascading parameters).

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[vshapiro]

thank you
I'll try to find