Grand totals page

We have a report that includes a list that expands down to 17 inches to accomodate two pages for a report and this list is grouped on a particular location. Each report is grouped by State. So in each state there can be many locations that report various items that comprimse two pages.

Now, what we need is a "state grand total" page and I am wondering about the best way to go about doing this. We do not want to create a new report with a separate stored proc that returns grand totals. What we would like is to do a running total or something like that. I could then include this on a subreport, but I need it to be the last page. For some reason, I thought there was a Report Footer section, but I only see Page Footer.

I hope I made myself clear enough and not being too confusing and I many thanks for any helpful information.

guyinkalamazoo3 wrote:

We do not want to create a new report with a separate stored proc that returns grand totals.

This is how I handle it. The auto total feature in RS is horrific IMO.

Got Memory?

Here are some perf counter stats from a box I am trying to better performance on:

buffer cache hit/avg 99.5

page reads/sec 5000

stolen pages 114000

page life expectancy 5!!!!!!!!!!!!!!!

the server is x86 sql 05' std. with the 2gb cap w/o awe enabled config. 2 Xeon 3.06 GHZs physical CPUs each dual core thus 4 logical CPUs with total system mem of approx 3.75 gb.

that page life metric is very concerning to me I am new to tuning sql memory but I would like to know right off the bat if his 2gb cap is not "gonna cut it" for his workload needs, I would hate to have to recommend 64 bit to him ahhhh, $$$. He actually has 3 identical boxes load balacned with a cisco device. (gets a ton of Inet traffic to the front-end Cold Fusion sites). His frontend app uses several DBs ranging in size from 4GB-42GB.

Thanks,

Derek

I changed the min/max memory options to both be aprox 2gb and now my page life exp jumped to 45 avg.