Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 14th, 2004, 12:38 PM
Registered User
 
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SubTotal Field

I have a report with a table with one group. In the group's Detail row I have a field that pulls an "Amount" field from the database. In the group's footer I want a subTotal field that shows the total of the "Amount" fields in the group. How can I do this?
 
Old September 23rd, 2004, 06:20 PM
BE BE is offline
Registered User
 
Join Date: Sep 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try dropping the amount field to the group row and reporting services should do an agregation by defauld, you should see something like =sum(field!fieldname.value)






Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal fields jsims Access 1 November 10th, 2008 11:34 AM
Subtotal yogeshyl SQL Language 1 July 15th, 2008 02:16 PM
SubTotal() to display in a label JayLou BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 April 11th, 2007 10:18 AM
QUERY SUBTOTAL NEWAGE Access 2 November 8th, 2006 11:59 AM
percent of subtotal mtlpp Excel VBA 0 May 14th, 2005 10:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.