if you are just looking for totals at your Report Footer per Status use the running totals.
You will need to create one RT per Status Type.
Create a running total as "Open Total"
Field to summarize as a SO number
Type of Summary as a COunt or DistinctCOunt dependingon what you want.
Evaluate as a "Use a formula": tblSO.Status="Open"
Reset as Never.
Place in report footer to get your number (and add a text box as a label to keep track of which one it is).
Note:If you place in the GF it will only count the records that have been read up to that point in the report.
Repeat the process for each status and replace/change the formula to = the different possible types.
If you must have this in a header you will have to use formulas (or a chart).
if you need that process let me know.
IP Logged
