Cascading parameters .... or some other idea..????

[vshapiro]

I have a report where I should give user possibility to select StaffType (01,02,03,04 or All). Then, depends which type user select he should go to different fields.


For example:
if user select 01 then he should select only from field CO_Manager (nothing else), if user select 02 then only from CO_Supervisor....etc

How can I do this. If Crystal does not do Cascading parameters - is it any other way do do it???


Thank you

 

[pgtek]

hi
can you give example of the data in the table

and what version of crystal

pgtek

 

[vshapiro]

I am using Crystal 9.0.
I have field StaffType with data 01,02,03,04.
And I have four fields:
Co_Manager
CO_Supervisor
RO_Manager
RO_Supervisor. Each field contain Managers/Supervisors IDs.

CO_Manager is StaffType 01
CO_Supervisor is StaffType 03
RO_Manager - StaffType 02....

So,for example, user select StaffType 01. He should be able to select Manager ID only from CO_Manager field and don't even have possibility to go to other fields.

Is it possible???
Thank you very much

 

[pgtek]

hi

just create a parameter on the stafftype

and link your parameter to stafftype field


cheers



pgtek

 

[vshapiro]

I have a parameter StaffType and I have all other four parameters - CoManager, COSuper..... But when I select one stafftype I still see all four another parameters.
How can I link to be able to see only one after I select particular StaffType????

 

[lyanch]

You can't in Crystal. Parameters each stand on their own and are not interdependant.

Lisa

 

[vshapiro]

Is it any other possibility to go around this problem in Crystal??

 

[IdoMillet]

Please avoid starting multiple threads with the same question (thread149-754185).

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[vshapiro]

I am looking for a way to solve this this problem - maybe instead of parameters I can use a formula somehow...