Interactive Sorting

  • I am trying to add Interactive Sorting on the the text bx which is using a lookup.

    Not sure how to configure Interactive sorting

    I went to Interactive Sorting

    Checked - Enable Interactive sorting text box

    Detail Row

    Under Sort By Expression added the lookup function

    LOOKUP(Fields!TeamName.Value,Fields!TeamName.Value,Fields!CountID.Value, "Dataset1")

    But its not working. Any Ideas???

  • sharonsql2013 (2/25/2015)


    I am trying to add Interactive Sorting on the the text bx which is using a lookup.

    Not sure how to configure Interactive sorting

    I went to Interactive Sorting

    Checked - Enable Interactive sorting text box

    Detail Row

    Under Sort By Expression added the lookup function

    LOOKUP(Fields!TeamName.Value,Fields!TeamName.Value,Fields!CountID.Value, "Dataset1")

    But its not working. Any Ideas???

    What are you trying to accomplish by using the lookup function in the sort?

    Usually you choose 1 field for it to sort on. It sorts according to the fields data type.

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

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