Results 1 to 1 of 1

Thread: Reporting Services matrix problem

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2004
    Posts
    541

    Reporting Services matrix problem

    Hello,

    I have a report in SQL reporting services 2005 in which I am using a matrix. Basically, it dynamically generates two years (ie 2006 and 2007) as a column header. this works great. Problem I'm having is a want to do a change year over year in one column at the end:

    example

    Insurer 2006 2007
    Insurer1 10 25
    Insurer2 13 45
    Insurer3 30 18


    I can't figure out how to create my own column on a matrix which just calulates the change year over year. All that is available is a subtotal which is not what I want. Here's what I would like to see:

    Insurer 2006 2007 Change
    Insurer1 10 25 15
    Insurer2 13 45 32
    Insurer3 30 18 -12

    I have to use a matrix because the year is based on user selection. If the years were not going to change, I would have just used a table instead of a matrix and hard coded the year. can something like this be done in a matrix?

    Thanks,

    Strick
    Last edited by stricknyn; May 8th, 2007 at 09:26 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width