Link to home
Create AccountLog in
Avatar of szadroga
szadrogaFlag for United States of America

asked on

SSRS sorting or SQL order by a column by another column value

i am looking to filter data on 2 columns but one column sort would be based on another columns value.

For example, i want to filter by Severity ASC, then by lastname but want these results not alphabetical but by the values of hours worked in another column.  So the first lastname to appear would be the one that has worked the most hours.
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Why can't you just sort by the "hours worked"?  Why does lastname come into it at all?
Avatar of szadroga

ASKER

looking for a "grouping" for lastname.  this way all the lastnames are together so you can see quickly how many tasks a person has charged time to.
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account