Home Forums Reporting Services Reporting Services Interactive Sorting RE: Interactive Sorting

  • February 26, 2015 at 3:03 pm

    #1780415

    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.