Sample Header Ad - 728x90

How can I first sort by color & then in alphabetical order in ssrs?

1 vote
1 answer
497 views
I'm still new to ssrs. In my query the color is determined by location. In my query I did ORDER BY [Location], Underwriter. Now this works perfectly fine in my query, but when I run it in SSRS it doesn't sort like in the query. I get thisenter image description here what I would like to do is first group the colors together and & set the underwriters in alphabetical order i.e. Balluka, Bill(light blue) Matanane, Brian(green) Walsh, Daniel(green) Davidson, Christine (pink) Hamilton, Marianne (pink) Karger, Tierney (pink) Marroquin, Melanie (pink) Sylvester, Todd (pink) Hopp, Robert (white) Lohr, Jeff (white) Raskovic, Hanna (white) Now what I tried doing in ssrs was in the design I right clicked underwriter> interactive sorting: tried sorting by underwriter & location but nothing happens when I run it. Please help s
Asked by user203633 (11 rep)
Mar 19, 2020, 05:07 PM
Last activity: Apr 19, 2025, 12:03 PM