arranging the data in a group in SSRS

• rshm35

  SSC-Addicted

  Points: 496

  More actions

  June 8, 2010 at 8:57 am

  #222479

  I have a table ,2 groups

  One group is County,other is Counselor

  County is the parent to the Counselor group.

  Now in the Counselor group the data related to counselor="No Counselor" should display first and then remaining data.

  How can I acheive this.

  Thanks in advance

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  June 10, 2010 at 9:58 pm

  #1179012

  Here you go:

  Select Row Group --> Click Sorting --> Click Add button and write following expression:

  =IIF(Fields!Counselor.Value = "No Counselor"," ",Fields!Counselor.Value)

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers