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.
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.
Microsoft SQL Server 2008SSRS
Last Comment
Brian Crowe
Why can't you just sort by the "hours worked"? Why does lastname come into it at all?
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.