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
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
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?
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)