SSRS hiding columns in cross tab

• Sam1980

  SSC Enthusiast

  Points: 128

  More actions

  July 4, 2010 at 1:36 pm

  #234640

  Hi All,

  I am creating an SSRS report as shown in the image below.

  http://img517.imageshack.us/img517/9629/reportq.jpg

  The report(cross tab) basically shows the scores/rating of each employee in a particular field(SQL, .NET etc). The city field is the the location where the employee works/resides and score is basically the strength of employee in the specific field. The Avg State score and the Avg Country Score shows the average scores for the state and the country respectively in a given field. The report will be run for a specific state(parameter). Since the State rating is going to be the same for all the employees, I want to show this at the end and I don't want to repeat it for all the cities/employees. Is there a way to achieve this? Please advice.

  Thanks in advance.

• gayathridevi.msit

  Ten Centuries

  Points: 1294

  More actions

  July 12, 2010 at 3:28 am

  #1191366

  Hi Sam,

  which field u want to show last.. can u plz be specific

  Regards,
  Gayathri 🙂