Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daisy
Starting Member
13 Posts |
 Posted - 2007-10-16 : 13:12:26
|
| I have a report that prints out each day totals on its own page. So I can run any time range with each day on a separate page. Ok. what I need is the very last page to print the grand totals from all the reports that ran during the range selected. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
daisy
Starting Member
13 Posts |
Posted - 2007-10-16 : 16:56:52
|
| My page footer already includes page number and total pages. |
 |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-16 : 17:00:13
|
| Add a "Report Footer"...with the totals. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-17 : 09:42:36
|
| I knew you meant "report footer"...of couse a page footer would technically work if the report was only one page. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-10-17 : 10:01:28
|
| Yep, that's what I meant, I was a little sloppy. Great catch, thank you! I don't think you can have total formulas in a page footer, that really wouldn't make much logical sense! (most reporting tools will not allow it; not sure about reporting services)- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-17 : 11:53:58
|
| I'm pretty sure Access will allow it...at least Acess97. Of course you would just put a SUM() field in the page footer...custom field...nothing special. I think it would give a sum for the page or something. Been a while since I built reports in Access though...but that's where I started out many years ago. |
|
|
|
|
|
|
Grand total page