Jump to content
Sign in to follow this  
BreAnna Porter


Recommended Posts

I have two layouts, and I would like to be able to combine them into another layout that will list information from both.

In one of the tables, teachers are able to evaulated the student's attitudes about various topics, in another table it holds the grading information, for each level, and the individual classes.

since each teacher is allowed to input their opinion of the student's attitudes I have created a summary field, which takes the average of the opinions for each level. The layout shows the class, the teacher, and their scores and at the bottom the average scores for that level.

On the other layout it shows the overall grade for the level, the individual grades for each class(basically its a transcript)

I would like to be able to create a coversheet that would list information from both reports as a summary

such that I would list what the average attitude scores per level, and the grades for that level.

I have learned that summary fields are position sensitive.

I have tried to write a statement

getsummary(studentscores::averagepart;course ID)and have placed that in a subsummary part in the report sorted by course ID...

however, it isnt giving me the correct answer. In fact its not giving me anything.

So my question would be how to place a sub summary field from one table into a layout based on another table?

Thanks a bunch,


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.