Crystal Reports How To — Parameter with All Value

Crystal Reports How To — Parameter with All Value

If the prompt is dynamic here’s what you need to do:

Using a command in Crystal Reports:

SELECT ‘0’ AS Code, ‘ALL’ AS Description UNION select Code, Description from inbrand

In Selection Formulas:

IF {?Brand} = ‘0’ THEN 1=1 ELSE {Command.BrandCode} = {?Brand}

Reference: https://archive.sap.com/discussions/thread/3626838

Reference: https://archive.sap.com/discussions/thread/1768301