February 21, 2007 at 4:03 am
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
February 21, 2007 at 5:22 am
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.
February 21, 2007 at 6:24 am
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..
February 21, 2007 at 2:45 pm
Can you move your SQL into a Stored Procedure and do your totaling there instead of in RS?
February 22, 2007 at 2:52 am
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!
February 22, 2007 at 4:13 am
if you right click on the row, of the categories can you not just use subtotal or have I missed something here?
Tris
February 22, 2007 at 8:05 am
🙂 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