tablix column grouping

• mick L

  SSCommitted

  Points: 1526

  More actions

  January 20, 2010 at 8:31 am

  #209256

  Folks,

  I need some help with the tablix column grouping.

  I am required to develop a report which has a structure that can dynamically expand horizontally.

  For an example dataset I have created two tables the first a set of laboratories and the second a set of chemical parameters

  SELECT columngroup2.labname, parametertest.parametername, parametertest.value, parametertest.time

  FROM columngroup2 INNER JOIN

  parametertest ON columngroup2.labname = parametertest.labname

  giving the result

  labnameparameternamevaluetime

  lab1 param1 500 11am

  lab1 param2 700 12am

  lab2 param1 565 10am

  lab2 param2 23 7am

  Using a tablix and column groupings I would like to have one line for each labname and a column for each associated parametertest value

  e.g.

  lab1 ,param1,500, param2, 700

  lab2, param1,565, param2, 23

  Is this structure possible using the tablix and column groupings? My own attempts where I have row grouped on labname and column grouped on parametername, value, time have resulted in multiple rows for labname which is not what I am looking for. e.g.

  group1param1param2

  lab1500

  [blank]600

  lab2565

  [blank]23

  I just want one row per lab.

  Thanks

  K

• DanielG-259128

  SSC Veteran

  Points: 291

  More actions

  January 28, 2010 at 12:53 pm

  #1110314

  From your description, I do not understand why you group on value and time...

  group your rows on lab - correct

  Group your columns on Parm only - this gives one column per parameter.

  use sum of value in your detail