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":
<Filter>
<FilterExpression> = Fields!Field_a.Value </FilterExpression>
<Operator> GreaterThan </Operator>
<FilterValues>
<FilterValue> = 100 </FilterValue>
</FilterValues>
</Filter>
<Sorting>
<SortBy>
<SortExpression> = Fields!field_b.Value <SortExpression>
</SortBy>
</Sorting>
I wonder which way is more efficient in terms of application performance (such as response time...).
Start Free Trial