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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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