Report Builder - Hiding a Column used for Sorting

• Chris Hewitt-261101

  SSC Eights!

  Points: 974

  More actions

  August 28, 2007 at 7:30 am

  #373707

  Hi there

   

  In report builder I am trying to sort on the month number, and display the month name. If I bring both the month number and name onto the report I can easily achieve this. The problem is that I don't want to display the month number. There doesn't appear to be a way to hide it.

  Any one know how to achieve this?

   

  Many thanks in advance

  Chris

• evaleah

  Ten Centuries

  Points: 1372

  More actions

  August 29, 2007 at 1:21 pm

  #730242

  This is not tested, only a theory but it should work.

  Create a group for month that uses the month number.  Then sort by that group.