• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 102 views
  • Users 0 members are here
Related

Multi select in Report Setup

Debbie Harland (Past Member)
$organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children
No Data