November 16, 2006 at 8:44 am
Hi.
This will probably be an easy fix, but just one I can't seem to see! I have a design in the report designer that for each consecutive day of the month lists the date, and transaction count - the listing of the transaction count is in fact a subtotal for each day.
How do I go about adding a total to the end of this, so that I can see the list of subtotals, and then the Grand Total at the end?
Ay ideas? The usual (sub)totalling methods don't give any joy..
Thanks in advance,
David
November 17, 2006 at 10:23 am
David,
It is an easy fix. When you sum a field in the footer there is not requirment that it is the field that you used for the detail. In your query or stored procedure , create another field which is not a subtotal and can be added togeater to get the total that you need. If that does not work , you can use a derived table or temp table to add the "Total" field to your result set, However if you use this method be sure to use the first function on your report rather than sum. Hope this helped.
Thanks,
George
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply