Parameter record selection dynamic and static

[FrankTWall]

Crystal XI, SQL server.

I have a report I need the users to either select a SAP ID or a Customer name.

I have set up dynamic parameter for the customer name and a static parameter for them to enter the SAP ID.

I have a third parameter that allow them to chose whether they want to search by SAP ID OR Customer name.

I can't get the record selection formula/ parameter prompt logic correct to allow this to occur.

I am thinking there has to be a smarter way around this problem. More detail can (obviously) be provided if it is required.

 

[synapsevampire]

Recordselection:

if {?SAP or Customer} = "Customer" then
{table.customer} = {?MyCustomer}
else
{table.sap} = {?MySAP}

They will be prompted for both though.

-k

 

[FrankTWall]

Thanks K,
I had used this formula with success but I was wanting to go to the next "step" where if they were prompted for the SAP ID , that was the only parameter requiring data and vica versa. Using this formula requires the user to enter both.

I think one of the issues is that the customer parameter is dymamic and therefor I can't fudge a value there such as "All" Any other ideas?

 

[FrankTWall]

Played around with this some more. Works well but I will have to educate the users that even though there is a default value appearing they are still searching by either the customer name OR SAP ID. Thanks

 

[synapsevampire]

You can fudge a value of all, you can use a Command object and a UNION,asin:

select "...All..." Customer
UNION ALL
select distinct Customer from customer

It gets a bit trickier though...

-k