Totalling confusion!

  • Hi.

    I have a report running against a small application that I'm having a little trouble with:

    The report is for one of our Operators, and it's a rolling daily report. The main column is the Transaction Type: split into deposits, withdrawals, and purchases. A sub-column under those transaction types lists the channels they occured through: JME, WAP and WEB.

    Running the SQL script within a SQL 'scratchpad' brings a up a list of transactions based on the above and through Reporting Services I am able to build a report that lists one row for each day of the current month and the number of transcations, and total (in terms of £'s) for those transctions; for each column and sub-coloumn.

    What I can't seem to do is make it add up the columns and give a total at the bottom of each column such that I can see a 'grand total' of transactions and amounts at the bottom of the report for each of the deposits, withdrawals, and purchases columns.

    Can anyone help me out here? Seems a simple thing to me, but just can't seem to get it to do it!

    Thanks in advance,

    David

  • Do you want just a grand total for each column or by channel?  If it's juts a total, then just use the SUM function in the table footer.

     

  • Hi. Thanks for getting back to me. This makes sense, although there's no option to add a table footer as it's a Matrix as opposed to a normal table.

    You were correct; just a grand total for each colummn. Basically, the Channels appear collapsed, and there's a column that gives a total across all Channels, and when expanded you see the figures for each Channel that make up that total - but that's aross rows.. Now I need to total the columns..

  • Can you move your SQL into a Stored Procedure and do your totaling there instead of in RS?

  • Would love to, as it makes sense.. however my background is network and web infrastructure and security, not DBA. So my skills here are limited to say the least!

  • if you right click on the row, of the categories can you not just use subtotal or have I missed something here?

    Tris

     

  • 🙂 I wish.. there's no option there for it unfortunately.

    David

Viewing 7 posts - 1 through 6 (of 6 total)

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