Parameter selection

[dr223]

Hallo,

I have a drop down list in my parameter (System Version) with fields A,B and C ONLY. The database has extra fields A,B,C,D and E. When I select All and run the report it brings forward all the versions i.e, A, B, C, D and E. Regardless, D & E being not in the drop down list. Please can anyone tell me how I can modify the formulae not to include the other versions i.e., D & E.

Please note, just for explanation I have A, B, C, D & E, but I have over 50 versions in the application. Thanks

(if {?System Version} = "ALL" then TRUE
else {DistinctGP27.CLINCOMP} = {?System Version})

[mbarnett]

it would appear to me based on your example that the system version is always 'ALL'

remove that to only have the
{DistinctGP27.CLINCOMP} = {?System Version}

to see if this is the case.