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

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

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

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.

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

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.

mlmcc

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

Group2 - Instructor

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

mlmcc

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...

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.

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

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.

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

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...

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

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

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.

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.