Crystal 8.5
Is the following possible:
Depending on the value selected within a specific parameter is it possible to change the table and field name required for selection:
For example:
------------------------------------------------------------
Switch (
{?AnalystType}="Action",{ASSYST_USR_Action.ASSYST_USR_SC}={?Analyst}
,
{?AnalystType}="Incident",{ASSYST_USR.ASSYST_USR_SC}={?Analyst}
)
------------------------------------------------------------
If the user selects 'Action' within the {?AnalystType} parameter then hopefully only records with {ASSYST_USR_Action.ASSYST_USR_SC} matching {?Analyst} will be retrieved. Similarly, if 'Incident' is selected within the {?AnalystType} parameter then only records with {ASSYST_USR.ASSYST_USR_SC} matching {?Analyst} should be retrieved.
As you have probably realised the above formula doesn't actually work, and in all honesty the more i think about it the less likely i believe this is possible.
However i am hoping to be proven wrong...
Thanks in advance,
Is the following possible:
Depending on the value selected within a specific parameter is it possible to change the table and field name required for selection:
For example:
------------------------------------------------------------
Switch (
{?AnalystType}="Action",{ASSYST_USR_Action.ASSYST_USR_SC}={?Analyst}
,
{?AnalystType}="Incident",{ASSYST_USR.ASSYST_USR_SC}={?Analyst}
)
------------------------------------------------------------
If the user selects 'Action' within the {?AnalystType} parameter then hopefully only records with {ASSYST_USR_Action.ASSYST_USR_SC} matching {?Analyst} will be retrieved. Similarly, if 'Incident' is selected within the {?AnalystType} parameter then only records with {ASSYST_USR.ASSYST_USR_SC} matching {?Analyst} should be retrieved.
As you have probably realised the above formula doesn't actually work, and in all honesty the more i think about it the less likely i believe this is possible.
However i am hoping to be proven wrong...
Thanks in advance,