Multi-pick field link

[SLXAdmin]

Hi,
I am working with Crystal 8.5 in SalesLogix.
I am trying to link one multiple pick list with the State field in another table.

The pick list contains the States and there can be more than one state chosen.

I would like to link these fields so that the report returns all accounts located in all of the states chosen in the picklist.

Any suggestions?

 

[synapsevampire]

CR 8.5 doesn't support dynamic parameters, so if something changes, it will not update the list automatically.

In CR 8.5 you can automatically read in all of the States from the table, and then I would place at the top of the list an "All", so that they can select everything readily, then in the Report->Selection Formula->Record place:

(
if {?MyStateParm} <> "All" then
{table.state} = {?MyStateParm}
else
if {?MyStateParm} = "All" then
true
)

-k