Using Static and Dynamic Cascading parameter together

[suburbanites]

HI. I' using Crystal XI SP1.

I am trying to use a static parameter and dynamic cascading parameter together in a report but I don't know how to pick either the one or the other - not both at the same time.

Would very much appreciate any help on this..

Thanks

 

[suburbanites]

Static Parameter is Company Name like "Production" or "Development" or "Other"

Dynamic Parameter is Company like 1500 or 2000 or 3000 and
Accounting Unit is "Beverages" or "Beer"

I would like to be able to say that if "Production" the ignore Dynamic Parameter else if "Other" then only then will the dynamic parameter be filled in.

 

[lbass]

You didn't explain what is to happen if the company is "Development", but anyway, I think you could set it up like this:

(
(
{?CoName} <> "Other" and
{table.company} = {?CoName}
) or
(
{?CoName} = "Other" and
{table.companyno} = {?CoNumber} and
{table.acctunit} = {?AcctUnit}
)
)

I believe you will still have to make selections for the dynamic, cascading parameters (even though they will have no impact on the selection), so you might want to use a command for the list of values where you add in options of "None" for the two values, as in:

select table.`companyno`, table.`acctunit`
from table
union
select 'None','None'
from table

-LB

 

[suburbanites]

Thank you so much LBass. As always. It works...