sql server reporting services: Subtotal at the End Of Each PAGE -- sql server reporting services

Subtotal at the End Of Each PAGE

John
9/15/2004 8:33:14 PM

sql server reporting services: Can someone Please help me.

I need to have a Subtotal at the end of EACH PAGE.
Please give me a sample, or a link or please tell me where to look.
I seached hi and low for 2 weeks now and still could not come up with
a solution.

If this functionally is not available in RS could someone please let me
know...
I don't have the work around and Don't know where else to look.

Please HELP!
THANKS,
John

Re: Subtotal at the End Of Each PAGE

John H. Miller
9/17/2004 12:35:22 PM

You may be able to use either the Rownumber or RunningValue functions to
force a grouping break at the end of each page where you can calculate the
sub-totals, assuming this is a simple list or table. There are a couple
example in the RS Books On-Line as well as earlier postings to this alias
that show how to use both.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@online.microsoft.com

[quoted text, click to view]