Advertisement

10.12.2008 at 08:51PM PDT, ID: 23808520 | Points: 250
[x]
Attachment Details

Filter and Sorting in RDL

Asked by treehouse2008 in MS SQL Server, SQL Server 2005

Tags:

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
[+][-]10.13.2008 at 05:45AM PDT, ID: 22701870

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 06:46AM PDT, ID: 22702334

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 06:48AM PDT, ID: 22702356

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628