25 Reports Into One! Help!

[advlghtcon]

Our users currently have to run 25 seperate reports to obtain information. I would like to have one report list our 25 separate numbers. The problem is that each report has different selectors. As in, one excludes a certain criteria where another does not. Therefore, just the select expert alone does not help. Subreports take to long. I've tried to put in "If-then-else" scripting built as a formula field and couldnt get it to exclude any records. Am I on the right track with have 25 different formula fields on one report, each pulling the number we need? Is there an easier way to combine them all into one report? All we need is total numbers, nothing fancy. Any ideas would help.
This is a copy of some of what I've tried to no avail:

If {Trips.Initial Priority}<>&quot;Code 10 - Standby / Spc. Event&quot; Then
If {Trips.Initial Priority}<>&quot;Code 99 - Out of Service&quot; Then
If {Trips.Call Type}=&quot;ALS&quot; Then
If {Trips.Call Type}=&quot;BLS&quot; Then
If {Trips.Cancel Reason}<> &quot;Communications Error&quot;or {Trips.Cancel Reason}<>&quot;Data Entry Error&quot;
or {Trips.Cancel Reason}<>&quot;OOS-Cleaning&quot;or {Trips.Cancel Reason}<>&quot;OOS-Detail&quot;
or {Trips.Cancel Reason}<>&quot;OOS-Equipment&quot;or {Trips.Cancel Reason}<>&quot;OOS-Mech. Critical Failure&quot;
or {Trips.Cancel Reason}<>&quot;OOS-Past Off Time&quot;or{Trips.Cancel Reason}<>&quot;OOS-Personnel&quot;Then
If {Trips.Dispatch Time}=&quot;00:00:00&quot; Then
Count ({Trips.Taken Date})
else
0;
Thanks,

 

[synapsevampire]

I don't think that you're on tyhe right track.

For best results on design, don't post what you think will work, post Crystal version info, database and version, example data and expected output.

Once you've done this, it should be easy to devise formulas to perform counts.

Here's some general formula help, your logic makes no sense:

//The first part might better be:
If not({Trips.Initial Priority} in &quot;Code 10 - Standby / Spc. Event&quot;, &quot;Code 99 - Out of Service&quot;

and

If {Trips.Call Type}=&quot;ALS&quot; Then
If {Trips.Call Type}=&quot;BLS&quot; Then

//The above is illogical, it can't be equal to both of those values...

-k