Post reply

Limit data retrieved to a Matrix

  • 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.

  • 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

  • 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!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply