sorting a report bases on a defined column

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  January 16, 2016 at 12:05 am

  #323635

  HI,

  I a m kind of new to SSRS. I have a report which I need to sort based a column which defined with lookup with two different datasets and two diffeernt values, hence the new column in not part of base query (Dataset name of Tablix).

  I tried defining calculated column on base data, but lookup is not allowed in calculated filed. My queries are MDX and sort is based on values in two different coumns from two diffeerent datasets. Is there any other solution for this ?

  Thanks,

  VG

• Spiff

  SSCertifiable

  Points: 7766

  More actions

  January 18, 2016 at 4:42 am

  #1852469

  You can use a Lookup in the sort expression of a Tablix.