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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics