Concatenated Field Parameter 1

[slimshades26]

How do I use a concatenated field ie:
formula: {A.ISPRP4}&{A.ISDSC1} in a parameter?
It is not a choice and in addition I will not be able to pull default values because it does not exist in the data base as @formulaname but as the two distinctive fields. Thanks for any input. ss26

 

[rhinok]

[ol][li]Create a parameter (?Parameter})[/li][li]Create a SQL Expression that is the concatenation of the two individual fields:
//%SQL Expression Example
//Exact syntax depends on your database driver
//I've used Oracle 8i Native in this example
CONCAT("a"."ISPRP4","a"."ISDSC1" )[/li][li]Modify your Record Selection Criteria:
//Sample Record Selection Criteria
{%SQL Expression Example} = {?Parameter}[/li][/ol]Try to use a SQL Expression instead of a Crystal Formula because the SQL Expression will be processed on the Database Server whereas the Crystal Formula will be processed on the client machine.