Limit data retrieved to a Matrix

• Gregory W Pfeifer

  SSC Enthusiast

  Points: 121

  More actions

  August 3, 2005 at 12:49 pm

  #109884

  I have a Matrix in reporting services which receives its data from a stored procedure,

  I want to limit the number of months displayed and use the remainder of the data to sum.

  EX:: I want to display the sum Hours worked by employee/month/location for the last 6 months and then sum the remainder of thier employment time.

  I am grouping on Location and Month.

  Any ideas.

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  August 4, 2005 at 5:59 am

  #579510

  Note sure you could do this with a matrix, but you could play games with a table and then use the RunningValues to populate each of the individual months based on the month the column contains.

   

  Dave

• Gregory W Pfeifer

  SSC Enthusiast

  Points: 121

  More actions

  August 5, 2005 at 9:59 am

  #580097

  After much research, mathematical manipulation is pretty much the limit of expressions used in a matrix.

  As David mentioned, you will have to do the data manipulation thru your queries and datasets.

  Thanks for all the help!

  The only way to Learn is to ASK!