Multi select in Report Setup

Debbie Harland (Past Member) $organization over 8 years ago

Hi All,

I have a report which requires parameters of Season and Production Season, the second based on the first. Problem is that both of these need to be multi select. If I make Season multi select, it has to be a text field, which doesn't work for the WHERE clause of parameter 2, Production Season.

I tried to create a View, but couldn't get it to convert the text field passed from the Season parameter, to do the select on the Production Season.

Has anyone successfully done this?

Thanks, Debbie

John A. Moskal II $organization over 8 years ago
Debbie,

Try this to make both Multi-Select.

For the Season parameter, use:

Data Type: String

Table: VRS_SEASON (or TR_SEASON)

Display Column: description

Data Column: id.

For the Production Season parameter, use:

Data Type: String

Table: T_INVENTORY

Display Column: description

Data Column: inv_no

Where Clause: inv_no in (Select prod_season_no From T_PROD_SEASON Where charindex(','+convert(varchar,season)+',',','+<<p1>>+',')>0).

Change P1 to PX where X is the placement in the list of the season parameter if it is not 1. Let me know if that helps.

John
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Debbie Harland (Past Member) $organization over 8 years ago

Thanks John! That worked a dream, exactly what I wanted.

Debbie
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel