February 25, 2015 at 8:54 am
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???
February 26, 2015 at 3:03 pm
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