Setting up a multiple parameter report

  • Hi,
    Im looking to setup a multiple value parameter based report. I found some instructions which demonstrate how to do this by using the In function within your query
    FROM
      [Report]
    WHERE [Report].order_no IN (@SalesOrderNumber)

    Setting up your Parameter as a multi value parameter and adding =split(Parameters!SalesOrderNumber.Value, ",") into the Dataset Parameter Properties.
    If I do this it errors with
    The Value expression for the query parameter ‘@SalesOrderNumber’ contains an error: Conversion from type 'Object()' to type 'String' is not valid.
    Any ideas how to overcome this?
    Thanks as always

  • Really sorry - managed to overcome my own issue with =split(JOIN(Parameters!SalesOrderNumber.Value,","),",")

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply