Running Total or Summary base on a formula?

[Soleil525]

Hi,
I’m creating an annual summary report. The summary is based on the case status and within a specific month. For example, in January I have 30 open cases, 25 pending cases, 5 closed cases, etc…

My first approach is to create this formula:

If {case_status} = ‘whatever status’ and
{case_create_date} in Date(01-01-2001) to Date(01-31-2001) then
1
Else
0

I place this formula in the detail section than insert a grand total of it. (Detail section is suppressed)

My second option is using Running Total. Both methods return the same result. My question is which of these methods should I use that will benefit the report processing speed? Currently, I have six statuses to summary by twelve months in a year. So I have about 72 summaries in the report footer. Your help is greatly appreciated.

TIA

 

[IdoMillet]

I don't know which of these approaches would be faster
(I suspect the first one), but unless you have special formatting requirements, you can do all of this
without any formulas using a CrossTab.

Cheers,
- Ido



ixm7@psu.edu

 

[Soleil525]

Thanks for your suggestion. Unfortunately, Cross Tab will not do the job because there are too many limitation. Thanks