SQL Server Performance

Problem adding rows/column in a matrix

Discussion in 'SQL Server Reporting Services' started by dougwood, Jan 30, 2004.

  1. dougwood New Member

    I have no problem doing this in a table format, however I can't seem to get column/rows to add up in a matrix format. It's a completely different scenario when you do this. Is there access to some sort of Row and Column objects for each render where I can set a
    Sum() function ??

    Thanks for any advice !
  2. jasper_smith New Member

    I must admit I'm not very sure what you're talking about [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] Do you mean adding subtotal rows/columns or do you mean for example adding an extra column on the right of an existing matrix to show a grand total for a row ?<br /><br />HTH<br /><br />Jasper Smith
  3. dougwood New Member

    Exactly Jasper, sorry I was a little unclear in my question, but yes, adding an extra column on the right of an existing matrix to show a grand total for a row .
  4. jasper_smith New Member

    If we take the Company Sales report that is in the Sample Project, you can add a total column to the right of the existing matrix by simply right clicking the OrderYear textbox (top right cell in the matrix) and choosing SubTotal. You will now have a new column on the right of the matrix that has the Total for the rows and will keep displaying the correct row total as you expand the various groups in the report.Hope this is what you mean [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />HTH<br /><br />Jasper Smith
  5. dougwood New Member

    that's exactly what I was looking for, thanks !

Share This Page