Post reply

Sorting - based on comparing two columns - ssrs 2005

  • October 11, 2012 at 6:44 am

    #263743

    i have 3 columns

    name stock level reorder level

    abc 10 5

    xyz 2 10

    efg 3 5

    i have to sort the data based on the condition "stock level < re order level" ,stock level < re order level rows must come first. can anybody tell me how to write expression for this in table properties - sorting .

  • October 11, 2012 at 8:20 am

    #1548149

    yudy.varma (10/11/2012)

    i have to sort the data based on the condition "stock level < re order level" ,stock level < re order level rows must come first. can anybody tell me how to write expression for this in table properties - sorting .

    Add an ORDER BY clause to your query.

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply