sorting by calculated column in table
Hi,
I have a table object and 3 columns within it. The last column is a calculated column (count of IDs). I'm trying to sort by that calculated column so that the total count of each ID is listed in descending order. I can't seem to figure
out a way of doing this easily in SQL Report Builder 3.0.
Any help would be appreciated.
June 21st, 2011 2:57pm
Ok. I got this to work by grouping on all the non calculated columns and then right clicked on Group Properties>Sorting>Add sort and recreated the calculated column and sorted descending.
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2011 3:43pm
Hi vba123,
Please marked the thread "As Answer" if your issue is been fixed.
Thanks
KumarKG, MCTS
June 21st, 2011 4:43pm