Totaling Totals?

[amoeba102]

I am having difficulty with a report of students taking courses during a specified time period. I need to know how many took 1 course only during the period; how many took 2 courses during period; how many took 3 courses and on and on ad nauseum up to 16 courses.

It seems every time I'm almost there I run into the problem of trying to total totals, which Crystal doesn't like.

I've used a selection formula to restrict it to active students during the specified time period. Can someone point me in the right direction to go on this?

 

[dgillz]

Right click on the database field you want grand totaled, and select "insert grand total".

Do this on the database field in the details secton, not on the subtotal field. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[amoeba102]

Sorry, I don't need the number of courses, but the number of people that took 4 courses, etc. I've grouped by student (by using SS#). I know which students had how many courses from this summary inserted in the group header:

Count ({Enrollment.Course Name}, {BGS-Data.SS#}).

This gives me the number of courses for each person. Now I just need to add up how many students took exactly/only 4 courses.

What is the 3 formula method? In reading past posts it seems that may be my answer.

 

[dgillz]

What about all the people that took less than or more than 4 courses? Do they need to be on the report at all?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[synapsevampire]

Please provide an expected layout of the report, table design and sample data.

You may be able to leverage a crosstab to simplify things, or you may have to build counts for each condition, this is based on your table design and requirements.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[amoeba102]

final layout is like a crosstab and will look something like:


0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 TotalUniqueStudents TotalCourses

timeframe1 x x x x
timeframe2
timeframe3

with the numbers across the top being the number of courses and the x's being the count of students taking exactly that number of courses in the given time period. Then there are the two types of totals at the end of each line.

 

[synapsevampire]

Hmmm, with exception to the TotalCourses, you had a crosstab fitted perfectly...

I fear you may have to hand roll this by grouping on the time field, and creating conditional Running Totals or using variables to count the students.

Running Totals have an Evaluate->Use a Formula where you can individually define what is counted. SO this would mean 18 running totals laid out alongside each otehr in the time group footer, with reset at change of group->time field.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com