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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
Why can't you just sort by the "hours worked"?  Why does lastname come into it at all?
szadrogaAuthor Commented:
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.
Brian CroweDatabase AdministratorCommented:
So it sounds like you want to order by an aggregate value while your are displaying at the detail level.  You would need to provide aggregate data at the detail level to make this happen.

You can do this in your query by joining against aggregate data but since I don't know anything about your schema or report I can't give you much in the way of direction.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.