In RDL, we can do filter and sorting in Query: "Select * from tables where field_a > 100 order by field_b", or in "Filters" and "Sorting":
<FilterExpression> = Fields!Field_a.Value </FilterExpression>
<Operator> GreaterThan </Operator>
<FilterValue> = 100 </FilterValue>
<SortExpression> = Fields!field_b.Value <SortExpression>
I wonder which way is more efficient in terms of application performance (such as response time...).