Add another dataset object

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  November 13, 2014 at 12:22 pm

  #301116

  I am trying to display data from different data sets in the same tablix.

  The challenge is when I try to add a spark line or a chart in one of the text boxes.

  I can go to expressions and select sums(value) but for category field , it somehow points to the same fields as in the tablix dataset.

  Is there a workaround?

• g.britton

  SSChampion

  Points: 13863

  More actions

  November 13, 2014 at 12:30 pm

  #1758373

  You can choose the dataset when you choose the field for the operation. It can be any dataset (and any field in that dataset) that is available.

  Gerald Britton, Pluralsight courses