In a student database, I have created a portal which details the student's enrolment. Example:

Subject Year Assessment Institution

Problem 1

I've created a new layout letter to advise the student of their enrolment details. However, if a student is enrolled in more than one subject, only the first subject in the portal appears on the letter. The 2nd and 3rd subjects in the portal do not appear on the letter. How do I resolve this?

Problem 2

I want to create a report in a new layout which indicates a subject and lists all students enrolled in this subject. How do I do this based on the portal above?

Edited October 15, 200817 yr by Guest

Problem 1:-

Do the report from within the subjects table.

Problem 2:-

You don't do this based on the portal. Create a relationship between students and subjects and do your report from within the students part of the relationship

hth

Phil

Thanks Phil.

Any chance you could elaborate on your solutions as I am a newbie and do not completely understand what you mean.

Edited October 15, 200817 yr by Guest

It's actually one problem and one solution. You have a many-to-many relationship between Students and Subjects, with a join table (Enrollments) between them. To produce the letters to students, you go to a layout of Enrollments (in List view), then sort and sub-summarize the records by student (the actual text of the letter goes into the sub-summary parts). To produce the report by subjects, you go to a similar layout of Enrollments, except this time you sort and sub-summarize by subject.

See the demo I have posted here:

http://www.fmforums.com/forum/showpost.php?post/246136/

It has both types of reports (in a very basic form) already built into it.

Good demo, however, I have a tricky situation. My database has portal made up of a many-to-many relationship, and I would like to have my data from the portal displayed in a report. However, it has to look like the JPG that I have attached. I have searched thru all documentation and forums, but cannot seem to get it to appear the way it should. Help?

Edited February 3, 201015 yr by Guest

Hard to tell from the picture what the issue is.

What I'm trying to do is create a report layout that will look like the picture I posted when I go to preview (before printing). However, it doesn't layout the fields properly from the portal. Everything lists in an outline form, when I want my report to list just like the picture. I believe if you click on the picture, it'll give you the full size. If you need to see my database, I am more than happy to show you the layout of it.

Please help?

Not sure exactly what you are having trouble doing.

You state that the report "doesn't layout the fields properly from the portal". Are you trying to print the items from within a portal?

"Everything lists in an outline form, when I want my report to list just like the picture". Does that mean you have an outline/border around your fields?

Is your skill level really "Advance"?

I'm having trouble creating a report from a portal. When I create the report layout and go to Preview, the report layouts are limited. I have the file attached. I want my reports to look like the JPEG I posted earlier. Hopefully this helps.

VoiceAudition.zip

Just curious if anyone has any suggestions or clues.

It would/may help if you attempted to script your report,laid out the fields that you want to show on the report layout (which is completely blank in your file), complete the calculation definitions and provide a few complete records with meaningful data in them.

For me, there is just too much to guess about in this file at the moment.

Sorry about that. It's actually Layout #7 that shows what happens when I create a report.

Still not much more information but attached is your file amended to have a report that looks like your mockup and another report showing the jurist scores in rows.

I have made a number of assumptions from the mockup and in your file, which may be wrong.

VoiceAudition_amended.zip

This is exactly what I was looking for help on! Thank you! It looks great!