Matrix Group on values in separate table

• wilks

  Old Hand

  Points: 325

  More actions

  May 10, 2011 at 2:58 am

  #389488

  Does anyone know if it is possible to build a matrix report where the group by column values are pulled from a separate table?

  I have a list of incidents I am reporting on and they have a type code. I don't want the table columns restricted to those which have occurred in the listed set of incidents. I want them to always refer to the values in a separate lookup table.

  I.E

  Building IncidentType1 IncidentType2 ..

  1 34(count) 23(count)

  2 21(count) 45(count)

  I want IncidentType1 and IncidentType2 columns to always be present.

  Thanks

  Matt

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  May 11, 2011 at 10:40 am

  #1323228

  Separate table, no. The way to handle this is to pull that separate table into your dataset query.

• wilks

  Old Hand

  Points: 325

  More actions

  May 12, 2011 at 1:32 am

  #1323504

  Thanks for the reply. I like that approach, ie including all the possible incident types, say with a left join in the query. What I can't get my head around however, is how to maintain consistent counts, if some of the rows aren't incidents at all but rows from the left join and purely standing data.

  I have got round the problem now by doing all the counts in a query, but it seems silly not to be able to use the aggregation functionality of the reports themselves. :ermm: