title: How do I reorder column groups on SSRS?
body: <p>I'm having issues with some column grouping on an SSRS report I'm working on. Essentially at the moment, the report is designed to pull two broad categories, let's say Category 1 and Category 2. But underneath, there can be more than one value in those categories. </p>
  
  <p>Currently the column group on the report shows category 1 before category 2. However, I want to show category 2 before category 1 which is fine, but at the moment it displays the last value from category 2 first. However, I want to show the first value from category 2 first, and then 2,3 etc and the same order for category 1 after.</p>
  
  <p>For example, Category 1 has values A, B and C and Category 2 has values D, E and F.</p>
  
  <p>Currently, I've switched the sort order on the report to Z > A for the category, and it now shows Category 2: F,E D and then Category 1: C, B and A. </p>
  
  <p>However, I want it to show Category 2: D, E and F and then Category 1: A, B and C. I'm not sure if I can use the SQL ROW_NUMBER() function in the SQL query itself, but at the moment, I'm not having much luck.</p>
  
  <p>Any help would be great.</p>