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})

[BrianL]

Hi dr223,

Which version of CR are you running? In the imbedded version of XI I use with my company's ERP software, a problem like this arose because the imbedded version is the Crystal Reports XI Standard, which can only support a static list of values in a parameter field.

In the "Append Parameter" file I've attached is shown the drop-down menu where you can Append all database values. Appending values will query the database and add all values currently in the field to the parameter's list.

The button seen above the drop down menu marked "Dynamic" is greyed out. That is a feature not available in the Standard version, and I have to manually Append for each Parameter.

In the "CR2008 Parameter" file it shows the CR2008 version of the same screen. In this version you can set it to Dynamic, and the Parameter will automatically query the database each time the report is run, and list the current values in the Parameter prompt.

I don't know if this is the problem, but it's something that I've run into that sounds similar. Hope it helps.

-Brian