Arranging Groups in Crystal Reports Design

Hello, I hope that you can lend assistance to me.  I am trying to arrange the grouped data in a report (evaluation calculations) so that the data will be the following order:

Total calculations for the entire Course
Calculations for each instructor (at least two)
Total calculations for The Facilities
Total Calculations for Knowledge Level
Total Calculations for Student Information

Example:

The Course
Instructor 1
Instructor 2
The Facilities
Knowledge Level
Student Information

What I am currently have:
Instructor 1
Instructor 2
the Facilities
Knowledge Level
Student Information


The parameters used is a date range and UserID.  I grouped on course, then grouped on the instructor.  This makes better sense.  I have tried on instructor and then course; and did not receive the results I wanted.  Currently, I am able to have the instructors information together, then followed by the Facilities, knowledge level, and student information.  I need to place The total calculations for the course above the calculations for the Instructor.  Due to total calculations based on change of group or class, I know that I needed to place the calculations in a footer.

Apart from the Header (with the details), the total number of evals collected is off becasue it's listed in the header, not the footer.  I could make that calculation a subreport I suppose.
 ScreenShotLayout.doc
mtroutAsked:
Who is Participating?
 
mtroutAuthor Commented:
Musalman,

              Thank you.  I'm not very comfortable sending sample data.  I will do the best that I can for now and maybe either understand what was told to me earlier, or figure it out.  I have been working on this for weeks and what has happened so far is that when I have swapped the group footers as described.  As a result, I received the instructor's name, then the course information, then the instructor's name, then the course informaiton again.  This is not what I want.  Not only that, the calculation for the course is increased each time.  This is not what I want either.  Although the Sums has been fixed to change on class number so that I may have the total calculations for the class.  

What I need is the individual markings (evals results) from each instructor from the same class.  When you look at the class as a whole, it should be a total calculation (rating) for each of the folloing:  The course, Facility, Knowledge, student information.

I recommend that for now, we close this call.  Thank you for your assistance.  But until I can really explain this well to others what I want to accomplish, I think that for now, I need to take the time, tear down and rebuild this again.  Then,  if necessary, revisit this question in hopes that I can explain it better.  Thank you again.
0
 
musalmanERP ConsultantCommented:
You need to add one more grouping level for the Course.

Lets Say your record would look like below:

The Course, Instructor 1
The Course,Instructor 2
The Course,the Facilities
The Course,Knowledge Level
The Course,Student Information

Then add Group on The Course, then you can show total at Group Header or Footer as required.



0
 
mlmccCommented:
Where you can present the totals depends on how you are calculating them

What data is available?

I suspect you are going to need to

Group on COURSE
    group header might have to totals for the course if they are summaries
Group on INSTRUCTOR
    group footer can have the totals or even the header again if they are summaries

You could add more groups but then they would be limited to data for a particular instructor

What information do you need for facility, knowledge level, and student?
To get these summaries I would recommend using a subreport linked on the course number and put in the course group footer.  1 subreport for each type

Another way would be to use formulas to gather the information and then display it in the course group footer.

mlmcc
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
mtroutAuthor Commented:
Hello, I will try adding another grouping for course.  for:
facility, knowledge level, and student?  These have totals pertaining to the course, not the instructor.  
First, I want to try adding another grouping for course.
0
 
mlmccCommented:
If they are simply related to the course then you could just add summaries on the appropriate fields and put them in the COURSE footer

mlmcc
0
 
mtroutAuthor Commented:
have added in another grouping for the course.  The design looks like what I want but the results are quite different.  I receive:

The Course
The Instructor
The Course
The Instructor
The Facilities
Knowledge
Student Information

I have formulas to do all of the calculations.  I may need to work on the subreport option and see how that will fair.  
 I have included some example attachments.

 Example-summary-3-28-11-userid-d.doc Screen-Shot-II.doc
0
 
mtroutAuthor Commented:
I thought that I was placing the "new" footer in the correct location so as to make the course appear once, then the Instructor (for as many times as needed; once if one instructor, or twice for two instructors), then follow with the Facilities, knowledge and Sutduent information.  Do you think that doing a sub report for the Instructor would be best?  I have tried that, but the instructors kept repeating and repeating. I linked on the same parameters.  I will try again, using the class number and see what results I will get.


0
 
mlmccCommented:
Group1 - Course
Group2 - Instructor

That will allow you to get the information for each course for each instructor

mlmcc
0
 
musalmanERP ConsultantCommented:
For this Case, there is no need of Sub Report,

As I told you, Make 2 Groups , and Put those fields in Group header that you want to show once per group.

Then Put those fields in detail which are appearing under the group...
0
 
mtroutAuthor Commented:
Mimcc, I have been grouping the data in the order that you have mentioned, but have some challenges in placing the data in the order that I want.  I have included an example in the previous response.  

Musalman, would I be out of line to ask for an example?  Somehow, I am just not getting it.  I have placed information to appear in the group header to show for each group.  That's done and it's tied to the class, where the class is the class number ,etc.  But the calculated information, I place in the footer.  I would appreciate an example.  Why I'm just not "getting it" or understanding what to do here...I have not clue.  It's just not my turn.

Thank you both again.
0
 
mlmccCommented:
What fields are each group?

You have 3 groups.
Group 1 - ? - is this facility?
Group 2 seems to be Course
Group 3 seems to be Instructor

If so it seems you have it done correctly

mlmcc
0
 
mtroutAuthor Commented:
Mimcc,

    Group Header #1 (I know that you did not ask about this), has the Class Information, where it's being taught, etc.

Group Footer #3, which appears next is the calculation for the Course
Group Footer #2a, which shows next in the design is the information about the instructor
and
Group Footer #1b which shows last, in the design and in the output is the Facilities, Knowledge, and Student Info.

I put in extra sections thinking that it would make things easier.
0
 
mlmccCommented:
Since you want Facility statistics that will cover all courses and instructors at the facility that should be group 1 as you have it

The next group depends on how you want the mix
If you want statistics on the course then individual instructors on the course then group 2 should be the course
The third group is the other one of course and instructor.

You have 2 and 3 reversed.

mlmcc
0
 
musalmanERP ConsultantCommented:
Mr/Miss mtrout:

Better if you attach final output with sample data in excel format that you r interested. It does not seem big problem, I will make it solve for you...
0
 
mlmccCommented:
Can you upload the report?
No data required

mlmcc
0
 
mtroutAuthor Commented:
Mimmc,

There are two files under this date and id        03/28/11 04:04 PM, ID: 35236147  They show the alternating course and instructor and I have included the latest.   Thank you.

  Screen-shot-3-30-11.doc
 sessionsummary-3-30-11-userid-da.doc
0
 
mlmccCommented:
What is wrong with the output?

Is there a COURSE group?

mlmcc
0
 
mtroutAuthor Commented:
The data calculation is fine.  I would like the output to look like this:

See the first page.

sessionsummary-3-30-11-B-2.doc



to have The Course information come first, then the instructors, then the facilities.  I am currently experimenting by placing the course information in the Report footer.  I am thinking to place all of the calculations in the Report footers.  Making multiple report footers, suppressing the other sections.  What is happening unfortunately is that well, if I place a subreport for the instructor in the footer, all of the instructors are written at one time.  If I copy the instructor calculations in the Report footer, it's only wirtten once.


The course group is NO_SCH.

 Screen-shot-3.doc  

Thank you
0
 
mtroutAuthor Commented:
Somehow, this time, I'm just not getting this.  I will recommend for myself to start this report over again from the beginning and hopefully get it how I want it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.