Count Multiple Specific Variables 1

[Oglesbay]

Hi all. I am trying to create a report using CR XI and am starting to run into problems. What I want to create is a quarterly report that will show each training class that we have taught, how many completed, how many canceled and how many did not show.

There are three variables that we use for these classes: F (Finished), C (Canceled) and B (Billed).

I have the classes broken down into two seperate groups, first by Class.Name, then by Class.Date. In GH1, I have the field Class.Context that displays the accurate number of each field. And in GF1 I have a summary of each field and no matter what I use (sum, count, distcount, etc..), I keep getting the TOTAL number of students regardless of status. Here is an example:

Class Status # Billed # Finished
Access
1/10/06 0 2
Student 1 F
Student 2 F
Student 3 C
1/31/06 1 2
Student 1 F
Student 2 F
Student 3 B
Student 4 C
7 7

Does anyone have any ideas? I would greatly appreciate it!

 

[synapsevampire]

Since you're displaying the total in GF1, create Running Totals for each type, select reset for GF1, and in the evaluate->use a formula add:

{table.status} = F

Chaning the F to the appropriate code for each total required.

-k

 

[Oglesbay]

Thanks for replying. Unfortunately, I don't follow what you mean. What do you mean by "select reset for GF1 and in the evaluate->use a formula..." Where is that?

 

[lbass]

You could either insert a running total (field explorer->running total->new) or you could create conditional formulas like:

//{@billed} to be placed in the detail section:
if {table.type} = "B" then 1

Then right click on the formula->insert summary->SUM, not count->choose the group level (or grand total) that you want for your summary. Repeat for each type.

-LB

 

[synapsevampire]

Hitting F1 and searching for Running Total would have resolved this, or use LBass's solution.

-k